I have a small Database split FE \ BE each user has a local copy of the FE on their desktop.
The FE settings are set to No locks and Shared.
The parent form is tied to a table. There is a sub form (tied to a table) on the parent form. The is a onCurrent event that checks to see if the main form has certain data, if it does the subform is shown.
Its very rare that the records are edited, just viewed again, the main use is adding customer calls.
The problem I have is that sometimes if a user is currently adding customer data and another user needs to create a new record, the DB locks and gives a message that its currently locked.
There are only 4 users at the moment, so they just harras each other to save their record until it unlocks. I know there are plans to add 5 more agents, so I'd like to understand why this is locking and a solution for it.
The FE settings are set to No locks and Shared.
The parent form is tied to a table. There is a sub form (tied to a table) on the parent form. The is a onCurrent event that checks to see if the main form has certain data, if it does the subform is shown.
Its very rare that the records are edited, just viewed again, the main use is adding customer calls.
The problem I have is that sometimes if a user is currently adding customer data and another user needs to create a new record, the DB locks and gives a message that its currently locked.
There are only 4 users at the moment, so they just harras each other to save their record until it unlocks. I know there are plans to add 5 more agents, so I'd like to understand why this is locking and a solution for it.
