argh! stops working when connecting to mysql LAN server

[icemonster]

so why is this happening? my thing is weird. for some reason, when i link the tables on the mysql server ms access stops working! any ideas?

 

[llkhoutx]

Can you view the records in any linked mysql table on the Access side.

You mysql tables are probably not properly linked and Access crashes because the first thing it does is access a linked mysql table.

 

[icemonster]

actually the problem was the driver, i used (during the time of the problem) a new released version of the driver which had bugs that's why it crashed. but it's alright now.

 

[mdlueck]

actually the problem was the driver, i used (during the time of the problem) a new released version of the driver which had bugs

With MySQL a few years ago, there was at that time two different suggested versions of Windows ODBC driver for MySQL. I deploy BOTH versions as I recall hearing that some things would work with one version and not the other version, and that neither version was "perfect" / preferred. I do not recall the version numbers of the drivers I have packaged.