Hi there
I have a question.
I have been using access for quite a while now. Some of the databases i have built up over the ages have gotten quite big and as a result - quite slow (partyly because of some of the formulae i have)
I have been looking for ways to try and improve the speed and filtering the queries has helped, but not enough and i have settled on using a SQL server (or an open source version of it - MySQL). As I understanding it, have a server attached helps alot.
My question is. If i build my tables in the MySQL Server and use Access as the front end (connected by ODBC) and i run the same queries as before - would i get any performance improvements or would i get the same performance issues because the speed is coming from the queries and not the location of the tables?