Locked register in Access 2000
-
Hi, I am having a problem when trying to update a table in Access 2000. At (apparently) random times, it throws the following exception. It is translated from spanish, might not be exactly the same in english; 'Can't update. This record is currently locked' There is no concurrent access to this database. Any ideas? Thanks in advance
-
Hi, I am having a problem when trying to update a table in Access 2000. At (apparently) random times, it throws the following exception. It is translated from spanish, might not be exactly the same in english; 'Can't update. This record is currently locked' There is no concurrent access to this database. Any ideas? Thanks in advance
The first thing I'd ask is, "Did you close all of your object when you where done with them? DataSet's, DataReader's, Connection's, ..." Don't keep a connection constantly open to a database. Keep it open only as long as you need to complete the transaction you need. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
-
The first thing I'd ask is, "Did you close all of your object when you where done with them? DataSet's, DataReader's, Connection's, ..." Don't keep a connection constantly open to a database. Keep it open only as long as you need to complete the transaction you need. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
Well I have a couple datatables pointing to the database through the same connection, but NEVER had problems until now. Thought the locking policy came into play when there was more than one user accessing the database. Still, I'll give a look and try to keep 'data objects' to a minimum. Thanks for the reply