Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rating: Thread Rating: 5 votes, 5.00 average. Display Modes
Old 04-14-2011, 03:43 PM   #1
Bechert
Newly Registered User
 
Join Date: Apr 2003
Location: Monroe, WA, USA
Posts: 59
Thanks: 1
Thanked 0 Times in 0 Posts
Bechert
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 is offline   Reply With Quote
Old 04-15-2011, 08:01 AM   #2
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,806 Times in 1,573 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
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 Record if you must but I would highly suggest that only as a last resort (if people keep getting an error of "someone else has edited this record..etc.).

Normally, even in a multiuser environment, you won't run into collisions very often unless you have a situation where more than one person needs to edit the same record around the same time and/or someone edits something and doesn't save and just leaves it there.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 04-15-2011, 08:43 AM   #3
DCrake
Administrator
 
DCrake's Avatar
 
Join Date: Jun 2005
Location: Burnley, Lancashire
Posts: 8,634
Thanks: 8
Thanked 310 Times in 208 Posts
DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light DCrake is a glorious beacon of light
Send a message via Skype™ to DCrake
Re: Error 3218 - could not update - record locked

You say a shared database. Are the front ends on each of the users machines or are they opening the same front end in a shared location?

__________________
David Crake


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
The Home of Simple Software Solutions.

O/S Windows XP (SP3) & Windows 7 64bit
Access 2003 (version 11.0)
Access 2007 (version 12.0)

Remember when posting sample databases you will get a better response if it is pre Access 2007 - not all people have it installed.
DCrake is offline   Reply With Quote
Old 04-15-2011, 09:44 AM   #4
missinglinq
AWF VIP
 
missinglinq's Avatar
 
Join Date: Jun 2003
Location: Richmond (Virginia that is!)
Posts: 6,127
Thanks: 11
Thanked 668 Times in 628 Posts
missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light missinglinq is a glorious beacon of light
Re: Error 3218 - could not update - record locked

Quote:
Originally Posted by bechert View Post
...each user has their own fe.


Linq ;0)>
__________________
The Devil's in the Details!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


(All code solutions tested in Access 2003/2007, before posting, unless otherwise noted.)
missinglinq is offline   Reply With Quote
Old 04-17-2011, 07:43 AM   #5
Bechert
Newly Registered User
 
Join Date: Apr 2003
Location: Monroe, WA, USA
Posts: 59
Thanks: 1
Thanked 0 Times in 0 Posts
Bechert
Re: Error 3218 - could not update - record locked

Bob, thank for the information. I will give that a try.

These users have the runtime version of Access 2007. I will need to send them an update.
Are the Database Locking settings in the FE?

Thanks,
Bill
Bechert is offline   Reply With Quote
Old 04-17-2011, 08:27 AM   #6
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,412
Thanks: 51
Thanked 940 Times in 910 Posts
gemma-the-husky is a glorious beacon of light gemma-the-husky is a glorious beacon of light gemma-the-husky is a glorious beacon of light gemma-the-husky is a glorious beacon of light gemma-the-husky is a glorious beacon of light gemma-the-husky is a glorious beacon of light
Re: Error 3218 - could not update - record locked

Bill

the trouble with locking records is JUST what you have described. The idea is to retain locks for the minimum period of time, and not to keep locks for an extended period

"No locks" is a bit of a misnomer. What it ACTUALLY does is rereads the record before updating the change. If it changed since it first read it, it reports the change to you - if it hasn't changed, it just writes your change.

So you get the benefit of both worlds - safe updates, without locking users out.

I am not 100% sure, but even if you have single record locking, the dbs may actually lock several records at the same time, because I think it has to lock the entire page/cluster on which the selected record resides - so it ALSO locks neighbouring records. (I think!)

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the top right of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Reply

Tags
3218 , locked record , record locked

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error 3188 -- Couldn't update. Currently locked by another session on this machine lmcc007 Modules & VBA 4 08-16-2010 11:24 AM
Error 3218 Could not update; currently locked. dealwi8me General 5 04-12-2006 10:00 AM
can't update record locked..... lipin General 4 04-04-2003 06:03 AM
Error Message - Record Currently Locked mathboy23 Forms 2 07-19-2001 06:38 AM
VBA Update Error 3218 Bloren97 Modules & VBA 2 05-16-2000 05:09 AM




All times are GMT -8. The time now is 05:52 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World