This tutorial uses Microsoft Access for illustration. To make Access work better with MyODBC, you should consider the following steps. You should have a primary key in the table. You should have a timestamp in all tables you want to be able to update. Only use double float fields.
Access fails when comparing with single floats.
Access can't always handle DATE columns properly. In some cases, Access may generate illegal SQL queries that MySQL can't understand. Once the data source has been created, you are back in the Select Data Source dialog. Select the data source you just created from the list. That should create a duplicate table on the remote database with all your data.