Ms Access 2007 Error 3218
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 04-14-2011, 03:43 PM #1 Bechert Newly Registered User Join Date: Apr 2003 Location: Monroe, WA, USA Posts: 50 Thanks: 1 Thanked 0 Times in 0 Posts Error 3218 - could not update - record locked Hello group, I have a multi-user application with split databases (BE/FE). The database is opened in Shared mode, Default Record Locking is set to Edited Record, Open Database by Record-level locking. Each user has their own FE. The users are physical therapists writing their treatment notes. The workflow is for the front desk to enter the patient information (name, diagnosis,etc.) and then the therapist treats the patient and writes their notes on a different form. It may take them 5 to 15 minutes to complete the note. Each treatment note form includes multiple memo fields. They receive the 3218 when they click the 'Save' button. The users report that no other user has the same patient record open (either at the front desk or another therapist) when the error is received. There are usually only 2-3 users using the system at any one time and it is is a small office so it is easy for them to verify if anyone is on the same patient. The error occurs several times a day. Appreciate your help. Thanks, Bill Bechert View Public Profile Find More Posts by Bechert 04-15-2011, 08:01 AM #2 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts: 32,482 Thanks: 94 Thanked 1,781 Times in 1,565 Posts Re: Error 3218 - could not update - record locked Change the option in the database options from Edited Record to NO LOCKS. You can then set the one form's locks to Edited Rec
the database. I edit data in a form, then use the form’s Delete button, which uses SQL to delete the record from the table. But I can’t delete the record because I get the error: “Could not update, currently locked†Anybody know what causes this error? Guest, Mar 6, 2005 #1 Advertisements Guest Guest Here is one possibility: BUG: "Could Not Update; Currently Locked" Error Message Raised by Second Edit Attempt in a Transaction http://support.microsoft.com/?id=331594 To get around this bug, you can issue http://www.access-programmers.co.uk/forums/showthread.php?t=208415 a Me.Undo in the Delete button’s Click( ) event prior to deleting the record with SQL. This will release a record lock on the edited record prior to the deletion. If my answer has helped you, please sign in to Microsoft's Online Community and mark my post as "Answered". Tom http://www.access.qbuilt.com/html/expert_contributors.html ___________________________________________ "M KING" wrote: I’m the only one using the database. I http://www.pcreview.co.uk/threads/error-3218-could-not-update-currently-locked.1106852/ edit data in a form, then use the form’s Delete button, which uses SQL to delete the record from the table. But I can’t delete the record because I get the error: “Could not update, currently locked†Anybody know what causes this error? Guest, Mar 6, 2005 #2 Advertisements Guest Guest here's my double click code to delete a record Private Sub DeleteRecord_DblClick(Cancel As Integer) On Error GoTo Err_DeleteRecord_Click If vbOK = MsgBox("Be advised you are about to IRREVERSIBLY DELETE THIS RECORD of this patient's (#" & Me![Patient Number] & ") !", vbCritical + vbOKCancel + vbDefaultButton2, "Critical") Then Me.AllowDeletions = True RunCommand acCmdDeleteRecord End If i placed the me.undo command in the corresponding click command Private Sub DeleteRecord_Click() Me.Undo 'this inserted per kb id#= 331594 about bug in ms access End Sub and YET i seem to continue to get the same 3218 error message. what's up with that? best, -ted Exit_DeleteRecord_Click: Me.AllowDeletions = False Exit Sub Err_DeleteRecord_Click: 'Ignore "error" if user cancels delete; otherwise ' show the error message. If Err.Number <> 2501 Then MsgBox Err.description End If Resume Exit_DeleteRecord_Click End
role in maintain a large amount of data in a sequential way, it is the very important application for small http://www.accessrepairnrecovery.com/blog/step-by-step-guide-to-fix-error-3218-could-not-updaterecord-locking-errors-in-ms-access to mid-sized enterprises and also used by many individual business owners for maintaining and running their valuable information. But sometime because of any minor or major corruption you cannot access the stored information from the access database, this is very dangerous situation for any because MS Access database corruption may harm its owner financially. There are lots of reasons ms access available that may affect the components of accmdb file and damaged it, once it gets corrupted then it display error message like: Error 3218 “Could not update; currently locked.” Error 3197 “The database engine stopped the process because you and another user are attempting to change the same data at the same time.” Error 3260 “Couldn’t update; currently locked by ms access 2007 user