Unanswered: Back end / front end--passthrough queries
If one were to, say, make MySQL or SQLServer as a back end and keep Access as a front end and you wanted to change from linked tables to using passthrough queries, is it a simple matter to copy the SQL of existing queries, replacing stuff like * with %, into a new query that is a passthrough query and add the connection string, and then use this new query as the datasource for your form or report? Are there speed advantages to using passthrough queries as opposed to linked tables, or is it just a matter of cutting the jet engine out for a more robust and stable database engine? After making all the passthrough queries would you just delete the linked tables--ie, are tables even needed any more in the front end after that? Thank you in advance for your time and responses.