I have a 2003 db that a lot of different users log in to but they can only see their own records. The Option is set for No Locks and Shared. But on one particular form, they keep getting an error message 'Could not update; Currently locked.
I have a table of users and passwords. They log in with the user name and password. That brings up a form filtered for just their clients. That form stays open and everything else they go into is filtered for that user.