myODBC with Access update issue

[Matthew Hartwig]

I am having a problem with using MSAccess (2003) on the front end of a MySQL DB (4.1.10a). When I add a timestamp field, the Access table will allow me to add the record and provides a proper refresh without a #deleted# record. When I attempt to update the table in Access, I get an error of SQL data out of range error. If I delete the timestamp field, I can update the record, but then get the dreaded #deleted# record information. MyODBC version is 3.51. I have upgraded the MDAC to the latest version.

Any help? It seems simple, but appears beyond me and my ability to find a similar issue on web and forum searches.

Thanks,

Matthew