5 replies
by dklippert
No solution, but here's the definition of the error:
Error 3218 ?Could not update; currently locked.?
This error occurs when a user tries to save a record that is locked by another user. To handle this error, program your solution to wait for a short period of time, and then try to save the record again. Or, you can display a message that explains the problem and give users the opportunity to try the operation again.
by frankus
by donq
Access enjoys both Passive and Sustained record locking. Under your menu options select Tools | Options and select the "Advanced" tab. Make sure Default Open Mode is set to Shared and Defaule Record Locking is set to No Locks.
The database still locks a single page of records during any update but locking is in the Passive mode and the lock is released as soon as the updated record is saved to disk.
by frankus
by frankus
This discussion is closed to new replies.
Trending Software posts
Sort by Trending