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.
Subject
Views
Written By
Posted
5499
May 18, 2005 01:34PM
2341
May 18, 2005 02:29PM
3026
August 30, 2005 07:25AM
2378
September 22, 2005 09:46AM
2686
October 10, 2005 06:25AM
2336
October 17, 2005 09:15AM
Re: Record Locking on Linked MySQL Tables
2318
December 04, 2005 11:17AM
2183
December 05, 2005 07:47AM
2163
January 05, 2006 04:13AM
2770
February 02, 2006 11:12AM
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.