Re: optimizing DB w/ access front end & MySQL backend
Ensure all queries use the sql server language, try to avoid using vba functions such as iif, dlookup, UDF's etc.
They can be a killer over ODBC because although the driver will make a good job of converting access sql to the host equivalent, anything that uses vba functions will need all relevant data 'passed back' for vba to evaluate.
If you have to use them, ensure the query is constructed in a way that the volume of data that vba needs to work on is minimised.
A little thanks goes a long way. If you have found this post useful, please tick the thanks button