Unanswered: MS Access slow with MySQL via MyODBC 3.51
I've just converted a relatively substantial database to use a MySQL 4.0.20a-nt back end with Access 2002 front end. All my indexes came over nicely and I've put the timestamps in as recommended for use with MyODBC 3.51.
Unfortunately when I bring up my forms they now take an age to show. What's strange is that the processor occupancy and disk utilization are at 0%, so it seems like Access is just suspended waiting on something.
Has anyone encountered this before and if so, what did you do to overcome it? It's really frustrating because I can see that there will be real advantages to using it once I get this speed issue resolved.