Cannot update; currently locked

[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.

 

[Guest]

Hi mich,
----------
I have a multi-user database (about 20 people at at time) that keeps locking

the users out.

The database is

not split - I know I need to do that, but I don't think that will solve the
locking problem.

-----------
I am not following you. How can a multi-user database is not splitted to
front end application and back end database ??

Is the problem that they leave the record open too long

before they sign out?

--------
I think so .

For this kind of situation, I will create disconnected recordset using XML,
then the users can update anytime they like.