Bug #28425 Access 2007 crashes when prompted for user name and password
Submitted: 14 May 2007 20:09 Modified: 17 Dec 2007 16:52
Reporter: Thomas Carr Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51.15 win32 OS:Windows (SP2 with Office 2007 )
Assigned to: CPU Architecture:Any

[14 May 2007 20:09] Thomas Carr 
Description:
File DSN does not work.

USER DSN works, but only with a valid MySQL user and password are embedded, if when prompted for user and password Access 2007 running an FE MDE or a MDB crashes. 

System DSN works, but only with a valid MySQL user and password are embedded, if when prompted for user and password Access 2007 running an FE MDE or a MDB crashes. 

How to repeat:
Relink Access to tables to MySQL 5.1 server with ODBC to prompt for user and password. 

Suggested fix:
???
[21 May 2007 8:04] Scott Cadzow 
This also appears to fail in Vista with Office 2007. Every connection via ODBC seems to crash the Office programme (Excel, Access, Word).
[25 May 2007 12:45] Varga Mihaly 
And also CodeCharge Studio 3.0 :-(
[4 Jun 2007 11:59] Richard Cuperus 
It also happens with MS-Access 2003/Windows XP SP2. MS-Access shows the tablelist, but crashes after selecting one or more tables. 

MS-Visio 2003 (Reverse engineer) also crashes when using Connector 3.51.15.
[11 Jun 2007 11:31] Tonci Grgin 
Thomas, thanks for your report and sorry for the delay in processing.
I do not have Office 2007 yet, and don't know when will I acquire one, so can this be repeated with Office 2003?

Richard, I am sorry but "just crashes" is not a bug report. My environment works just fine FileDSN (importing and linking several tables at once):
 - MySQL server 5.0.44BK on WinXP Pro SP2 localhost
 - MS Office 2003 fully updated
 - MyODBC 3.51.15 GA
[12 Jun 2007 10:16] Bogdan Degtyariov 
Verified on Windows 2003 Server/MS Access 2007/MyODBC 3.51.15
[30 Nov 2007 11:58] Yuriy Pavlyutkin 
Verified on Windows Vista/MS Access 2007/MyODBC 3.51.12
[11 Dec 2007 16:46] asdgf sdf 
I tried several versions and finally found a solution.

Using an older MySQL ODBC client with Access 2007 (on Vista) worked for me.

I used v 3.51.07 -> http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-3.51&v=3.51.07
[17 Dec 2007 16:41] Bogdan Degtyariov 
This bug has been fixed in 3.51.18 and newer.
[17 Dec 2007 16:52] Bogdan Degtyariov 
In order to avoid this bug please use binaries from here:

http://dev.mysql.com/downloads/connector/odbc/3.51.html