I have been struggling to deal with this and have done a lot of internet searching and forum searching trying to figure it out but I end up with more questions than answers. My users (anywhere from 8 to 25) intermittently get the error message "Could Not Save; Current Locked By Another User". The only solution seems to be everyone exiting the database then getting back in. I searched Microsoft information and forum information to understand the locking process. I gather that Access 2000 was the start of Record Locking and that record locking is actually Access opening a record and filling up a full page of memory then locking that page which means there is no real record locking in Access. I have looked at the Tool\Options\Advanced menu and understand the Default Record locking settings these are global settings. There is some suggestion that these are then only applied to NEW forms but existing forms retain their existing locking mechanism. Not sure if that is true. Also, the "Use Record level locking" checkbox being checked indicates record locking and unchecking indicates page locking. Now the problems.
No matter how much testing I do I cannot reliably recreate the "Could Not Save; Current Locked By Another User". I have tried several types of settings, used different computers, even different logins, every time Access uses optimistic locking. The only exception is when I set the form to use record locking. However, the behavior of this is far different from the problem my users experience. They are in the middle of editing a record and when they try to advance (thus save) the record the application hangs then produces the "Could Not Save; Current Locked By Another User" error.
I hope someone has not only a suggested solution but a method to create this error reliably. Without that any solution looks like a guess. Thank you in advance for any help.