Incease speed of Access

[Simon]

I have an access 2007 database using mysql back end with ODBC

What can i do to speed up the database as it sometime runs slow

Thanks

Simon

 

[John W. Vinson]

I have an access 2007 database using mysql back end with ODBC

What can i do to speed up the database as it sometime runs slow

Thanks

Simon

There are some general suggestions at
http://www.granite.ab.ca/access/performancefaq.htm

Of course Access can't help if the MySQL backend or the network is overloaded.

 

[David W. Fenton]

m:

I have an access 2007 database using mysql back end with ODBC

What can i do to speed up the database as it sometime runs slow

Probably you need to add appropriate indexing to the MySQL tables.