Err# 3218: Could not update; currently locked.

[reachvali]

Hi all,

I am supporting a MS Access application with 25 users.
I started seeing the below error regularly.
Err# 3218: Could not update; currently locked.

Application has Front End running locally on user machines. Back end shared database is on a network location.
What do i need to avoid this locking issue.


We are using Access 2003. May not be able to migrate to the latest version near soon.

Please advice.

thanks
Vali

[RuralGuy]

Assuming it is simply more than one user attempting to update the same block of data then you need to trap the error and either loop until the lock is gone or try again later. You may with to ask the user what they want.

[reachvali]

Thanks for the response.

Problem is Access is locking the entire database. No other users are able to insert a record. This is only happening in the new record creation. How to make settings to limit the locking to one record?

[RuralGuy]

Are you using queries of tables or just the tables directly for your forms? It should be queries. The initial behavior is set from Tools>OPtions...>Advanced. Here is the best MultiUser link I have ever found: http://www.accessmvp.com/TWickerath/.../multiuser.htm