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. When you are coding with the ADO API and MyODBC you need to put attention in some default properties that aren't supported by the MySQL server. For example, using the CursorLocation Property as adUseServer will return for the RecordCount Property a result of -1.