Hi Sir,
I designed a database in MS access to manage our patient record of Mobile Health Camp conducted in the field area. I have split my database and put the backend file in a separate PC which is connected to my local Area Network. The Front End is given to 10 Data Entry Operators who Enter the data at the same time.The database works fine on the Network but we have an issue which irritates our data entry operators during the Entry Process.
Now the Issue is that " When two or More DEOs start data entry its Hold them and dialog box pop up that the " Record is locked". After 2 to 5 second it allows the DEO to enter the Record.
Kindly guide me on how I can solve this problem. Furthermore, if necessary I can share more details as well as a database file for your reference.

Thank you