Re: Access crashes when i try to link tables to MySQL

[Bob Denny]

Ian Mayor wrote:
> [...]
> ODBC -- call failed.
> {ODBC 3.51]User cancelled. (#0)

Same here. Access 2003 with all applicable Office updates, MDAC 2.8, latest ADO/DAO, Jet SP8. In other words all of the Microsoft Data Access patches and updates I can find. I do not have any other databases (SQL Server, MSDE, whatever) - Just Access 2003 and the back end Jet database.

Also, I tried to programmatically create a linked table attachment in VBA by creating a TableDef object for the link and adding it to the TableDefs collection:

Dim td As TableDef
Set td = CurrentDb.CreateTableDef("LocalName", dbAttachSavePWD, "RemoteTable", ConnStr)
CurrentDb.TableDefs.Append td

Where ConnStr is an ODBC connection string that DOES WORK!!! (names changed of course!)

ConnStr = "ODBC; DRIVER={MySQL ODBC 3.51 Driver};" & _
" SERVER=mysql.foo.com; PORT=3306;" & _
" DATABASE=test_db; UID=guesswho; PWD=youdontknow; Option=35;"

I have used this connection string to retrieve and modify data from the remote MySql database in Access/VBA and also stand-alone JScript/VBScript applications.

Anyway, when execuding CurrentDb.TableDefs.Append td, Access hard-crashes with the "Send Billy a love note?" window that curiously has an Access specific recovery option.

I came to this forum to find an answer. No luck so far :-)