I have a split access 2003 database on a network, the front end (mde) is located each local computer with the backend (mdb) on the server. The tables are linked using a mapped letter drive. This is a multiple user environment with 2 to 3 users connected and entering data 24/7.
The problem is with the record locking, I need it to lock a record when it is being edited by another user. What is happening is it is sometime locking several records and it seems to be the record before the edited record and the record after.
So my question is two-fold first what type of record locking strategy I should be using and secondly where is the record locking suppose to be implemented, on the front ends or the back end or both
Server=Windows 2008 Server Standard
Client = Windows 7 and Windows xp