You don't have to specify values for the Server , User , Password or Port fields in the ODBC setup screen. However, if you do, the values will be used as the defaults later when you attempt to make a connection. You have the option of changing the values at that time. 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. Borland Builder 4 When you start a query you can use the property Active or use the method Open . 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.