Make sure that your MySQL database has been set up and that remote access has been enabled. You may contact support to set up MySQL or enable remote access.
Download and install MyODBC on your Access server.
Create a new Data Source Name using the MyODBC 3.51+ driver. The ODBC DSN screenshots refer to Windows 98, other versions may appear slightly different. You may skip to the bottom for MyODBC connection parameters.
|Open the ODBC control panel.
In Windows 2000/XP, the ODBC panel
Start->Programs->Administrative Tools->Data Sources (ODBC).
|Select the MyODBC 3.51 Driver.|
Enter the connection parameters. Select "Test Data Source" to determine whether the DSN has been configured correctly.
MyODBC connection parameters: