I use Access to work with several MySql databases by linking tables through the ODBC. First go to http://dev.mysql.com/downloads/connector/odbc/3.51.html[^] to download the ODBC driver for MySql. Create a DSN for the MySql database on your local computer. Open Access, go to File->Get External Data->Link Tables (be sure not to use import, because that will only work locally), and select ODBC in your file type drop down list. Under "Machine Data Sources", select the DSN you created. Select all the tables you wish to work with, and you will get icons for each under your tables list in your access window, except they look like globes instead of tables since they are linked tables. Now that you have the tables set up in access, you can work with them however you want, including queries, forms, reports...whatever.