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 . Allaire has verified that MyODBC version 2.50.26 works with MySQL version 3.22.27 and ColdFusion for Linux. However, the driver is not included with ColdFusion 4.5.1.