Create edit and manage MYSQL database from MS Access
This simple tool can help you to manage MYSQL dbase from MS Access without any knowledge of My SQL. User can easily modify /create/open tables within Access. It connects both the databases where you can edit,add and delete just like the normal ACCESS tables and then export the tables to the MYsql server.
Here is the tool download page
This tool was previously a paid software but now they are giving it free. Before trying this tool you must make sure that your MS-Access responds to MYSQL server VIA ODBC. You are suggested to use MyODBC 3.51.11-2 instead. This Version is known to work perfectly