Hi Victor,
In order to allow MS Access to talk to a MySQL database you need to use an ODBC driver, the latest version can be found here '
http://dev.mysql.com/downloads/connector/odbc/5.1.html';.
To create a connection to a MySQL database you need to go to Start => Control Panel => Administrative Tools => Data Sources (ODBC). Under the User DSN or System DSN click Add and double click MySQL ODBC 5.1 Driver and enter the details of your MySQL database and click ok.
Create a new MS Access database, in the Databases window right click the Tables tab under objects and select Link Tables. A file selection window will appear and at the bottom select ODBC databases next to where it says 'Files of type'. A Select Data Source window will appear, select the Machine Data Source tab and you should see the ODBC database connection you created ealier in the list, select this and click ok. This will give you a list of all the tables on your MySQL database, select the tables you wish to link to and click ok.
This will create a link to the MySQL database, any changes now made here will direclty reflect in you database. There are certain functions that will not work such as altering the structure of the database but most data manipulation functions should work ok.
Also ensure your MySQL database server will allow remote access to the database as some hosts will not, you maybe able to set this in CPanel or whatever control panel your host uses.
I hope this answers your question.
Kind Regards
Garry