Note that if you are using MySQL Version 3.22, you must to apply the MDAC patch and use MyODBC 2.50.32 or 2.50.34 and above to go around this problem. MyODBC option field when connecting to MySQL . 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.
Create instead a form with the fields you want, and use that form data sheet view. Access can't always handle DATE columns properly. In some cases, Access may generate illegal SQL queries that MySQL can't understand. If you are using Access 7.0, You should use the option flag Return matching rows . Return matching rows and Simulate ODBC 1.0 .