Guest_imported
New member
- Jan 1, 1970
- 0
One of our tables (dbase) locks, at a file level, often.
Several people can call up our form and use it at the same
time. occasionally they are getting "record is locked by
another user" error when they try to bring up the form. It happens even before they get to see a list of the records in the table that they can choose from. The error goes away when we have them all exit their instance of the form.
Once they had all exited the form, I began bringing up separate instances of the form then opening one record in each instance, going down the list of records in the table.
After I open a particular record, then no other instance of the form can open a record. The entire table is locked.
We cannot see anything out of the ordinary in the offending
record. We know that when we exit that instance of the form that has that record open, others can get into the table again.
Several people can call up our form and use it at the same
time. occasionally they are getting "record is locked by
another user" error when they try to bring up the form. It happens even before they get to see a list of the records in the table that they can choose from. The error goes away when we have them all exit their instance of the form.
Once they had all exited the form, I began bringing up separate instances of the form then opening one record in each instance, going down the list of records in the table.
After I open a particular record, then no other instance of the form can open a record. The entire table is locked.
We cannot see anything out of the ordinary in the offending
record. We know that when we exit that instance of the form that has that record open, others can get into the table again.
