I have a multi user Access database that is split into a backend on a shared drive and a front end held on the users PC.
On each PC the user is entering data into a form that is linked to a table on the backend. The form is set to dataentry and nolocks however I am having a problem with recordlocking.
Every so often 2 or more PCs have the message that the record is locked by a user on another PC. Has anybody got any idea on how i may be able to get around this problem.