Running MS Access queries for WAN hosted mySQL database I have a front end MS Access running through a backend MySQL database via ODBC, I recently moved MySQL database from a local LAN server to a hosted WAN server on Amazon RDS.  Now all of my queries are running very slow. By searching online I found the best way is to rewrite the queries in pass through mode so stored procedures are not running locally in Access.     I have tried VPN vs ODBC, didn't help. 

Problem with this approach is that I have thousands of queries (saved and in code) that run sums, dlookups and other Access procedures, it will take months to rewrite all of them correctly so the queries run on the hosted site.  

Is there another quicker fix solution to this problem?
You could run Windows server on AWS EC2 or a Windows Desktop using Amazon Workspaces and try running Access there in AWS's network environment.  That may significantly improve performance.  Another thing to consider is that network performance can be limited on micro instances.

There might be other advantages of hosting your whole application in the cloud in terms of uptime.