16 MySQL ODBC Support MySQL provides support for ODBC by means of the MyODBC program. We hope somebody will port it to Windows 3.x. This will help shed some light on any problems. 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.