MySQL Forums
Forum List  »  Microsoft Access

Re: Record Locking on Linked MySQL Tables
Posted by: Kira March
Date: December 04, 2005 11:17AM

Thank you!! This has been driving me nuts.

In my case, the problem was that a default value filled in by the MySQL database in a date/time field.
Access seems to do okay with text default values, but not this date/time one. I set the default value to null for the date/time field and the record locking problem went away.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Record Locking on Linked MySQL Tables
2318
December 04, 2005 11:17AM


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.