This will fix the bug in Access that when you export data to MySQL , the table and column names aren't specified. Note that if you are using MySQL 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 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 access MyODBC through ADO, MyODBC doesn't return a result for SQLRowCount for a query. We have tried to track this down and according to ODBC logs, MyODBC returns the correct answer but the ADO client only gets -1 back from the ODBC manager.