Record Locking Problem
Posted on 2007-10-16
Error: Could not update; current locked
(By the way I not asking about the below code, Im asking what could be causing the record locking I am seeing at many different times on many different tables.)
I have a database that I inherited from another programmer. The other programmer was getting locking errors and I have never had locking errors on any of my databases. So because I wasn't rewriting everything, I thought I wouldnt have any record locking with my stuff (my table and my forms etc.) I was wrong.
To give you an example the below piece of cod is run probably 50 times a day. It adds a record to a table that no one ever edits, it just adds two fields and has a third field that is an auto number Id field. Today for the first time in 3 months I got the error.
Could not update; current locked
Set db = CurrentDb
Set RS1 = db.OpenRecordset(tbl_PhoneNbr_Lookup, dbOpenDynaset)
RS1!CallLogHeaderchdr_Idd = lng_Id
RS1!Phone = strPhone
Set db = Nothing
Set RS1 = Nothing
************************* end of code
Some facts about their system
* About 6 users
* Each user has a copy of the program database
* The data database sits on the server
* I think some are using Access 2003 and some are using Access 2002
* They are in a different town, so the below they assure me is true, but I can personally verify it
* In Options, Advanced Tab
Default record locking --> No Locks
A checkmark in Open databases using record-level locking
Any help would be greatly appreciated.