Within our department, I have created a DB that has a FE and BE DB. The BE is located on a shared server, and each user within the department has the FE loaded on their machine. When a user goes into one form within the FE, it puts a lock on the DB. The lock prevents other users from entering the DB. Within the FE DB, this is the only form that the user is able to enter data that gets inserted into the BE DB. It sounds like my problem is within the design of the DB or this form. I don't know what I need to look at to solve this problem.
Thanks in advance!!