Record Locked

[Guest]

I have a multi-user database. It used to worked fine. But suddenly an error
message of record locked appears very frequently. User has to exit the form
to let other users to editing the record, even they are in different records.
For instance, user A in record #4 and user B is in record #5. when user A
wants to edit data in record #4, an error message of “Run-time error
–2147217887(80040e21)
Could not update; currently locked by user “Admin†on machine XXXX.

†appears, user B has to exit the form so that user A can edit the record #4.

I don’t know why ? Could any one please help?

 

[Joseph Meehan]

I have a multi-user database. It used to worked fine. But suddenly an
error message of record locked appears very frequently. User has to
exit the form to let other users to editing the record, even they are
in different records. For instance, user A in record #4 and user B is
in record #5. when user A wants to edit data in record #4, an error
message of "Run-time error -2147217887(80040e21)
Could not update; currently locked by user "Admin" on machine XXXX.

" appears, user B has to exit the form so that user A can edit the
record #4.

I don't know why ? Could any one please help?

You can try having everyone exit the program then if there is a file
YOURFILENAME.LDB, delete that file.

 

[Guest]

there is no such file.
any other suggestion?

You can try having everyone exit the program then if there is a file
YOURFILENAME.LDB, delete that file.

 

[Joseph Meehan]

there is no such file.
any other suggestion?

Sorry no. I have not run into the problem.

 

[RTL]

We get that sometimes. Have you compacted and repaired the DB?

Cheers,

Rich