Could not update. Currently locked

[mjn015]

I recently split my database and created an MDE file. Users were given a copy of the MDE file and the BE is in a shared directory on a server. There are only two users at this point in time inputting data into the database (there will be at least a dozen more in the near future), but every so often one of them experiences being unable to input data from their Form because of this lock condition. Sometimes the condition will go away (if they wait long enough) and they can input data again. Sometimes it's User A experiencing the lock, sometimes it's User B. I thought splitting would alleviate lock issues, but it doesn't seem to be the case for me. Could this be a "permissions" issue on the shared directory where the BE is located or some security setting within Access (or both)?

Thanks in advance for everyones help!
Michael

 

[The_Doc_Man]

More likely the form update mode is "Pessimistic" but should be "Optimistic" - just a guess. It's a property of the form, I think. If not, then a property of the query. But I really thing it's a form thing.

 

[mjn015]

Thanks Doc. Where do I find the Form's update mode?