MySQL Reference Manual for version 3.23.5-alpha. 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. Note that this is a bug in Excel, because it automatically converts a string to a time. This would be great if the source was a text file, but is plain stupid when the source is an ODBC connection that reports exact types for each column. Delphi You must use DBE 3.2 or newer.