MySQL Forums
Forum List  »  Microsoft Access

Advanced Search
New Topic

Re: cannot modify data in my "mysql" db via "Ms Access 2003"
Posted by: Martin King-Turner
Date: February 16, 2005 08:20AM

I've seen this problem when datatypes are set incorrectly. In my case, I had a field which started life as an Access Date/Time field that became a MySQL Varchar field when the table was exported to MySQL (for some reason I never figured out). When I then linked to the table, the linked table showed a datatype of Text in Access, but trying to update the records gave the error you see.

The resolution was to change the field to DATETIME in MySQL, refresh the link in Access so the field showed as Date/Time and then everything worked OK.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
cannot modify data in my "mysql" db via "Ms Access 2003"
2681
Mario Veilleux
February 16, 2005 08:12AM
Re: cannot modify data in my "mysql" db via "Ms Access 2003"
1833
Martin King-Turner
February 16, 2005 08:20AM
Re: cannot modify data in my "mysql" db via "Ms Access 2003"
1817
Andy Ver Murlen
February 28, 2005 01:46PM
Re: cannot modify data in my "mysql" db via "Ms Access 2003"
1781
Mario Veilleux
March 03, 2005 07:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.