G
Guest
I have a multi-user database (about 20 people at at time) that keeps locking
the users out. I know I'm doing something wrong, but not sure what it is.
Right now, the users open the form, choose from a combo box which populates a
time in another field. They leave the form open until they are done w/ their
particular task (could be over an hour). When they finish, they check off
another box, which populates the time and then requeries the form to get rid
of that record and gives them a new one. At random times throughout the day,
any individual will get an error message, "Cannot update; currently locked"
At this point, all users have to get out and log back in. The database is
not split - I know I need to do that, but I don't think that will solve the
locking problem. Is the problem that they leave the record open too long
before they sign out?
Any help would be greatly appreciated.
the users out. I know I'm doing something wrong, but not sure what it is.
Right now, the users open the form, choose from a combo box which populates a
time in another field. They leave the form open until they are done w/ their
particular task (could be over an hour). When they finish, they check off
another box, which populates the time and then requeries the form to get rid
of that record and gives them a new one. At random times throughout the day,
any individual will get an error message, "Cannot update; currently locked"
At this point, all users have to get out and log back in. The database is
not split - I know I need to do that, but I don't think that will solve the
locking problem. Is the problem that they leave the record open too long
before they sign out?
Any help would be greatly appreciated.