Unanswered: MySQL and MS Access integration and performance
Perhaps I trying to shoot a dead horse, but I would like to see if there is any advice on getting better performance from my application.
At the moment, the data resides in an MySQL 5.0 database and I use MS Access to provide a User interface (complex VBA etc). However, the performance is far worse then if the data resides within the MS Access application.
Can anyone suggest techniques of improving the performance between the two databases?
I simply use an ODBC driver - via Access to connect the two databases using linked tables.
Also I get an error "[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt] you have an error in your SQL syntax......" when trying to run a query. The query using specific MS Access SQL - "where exists in (Select....... ) = false" is this the problem?