Record Locked Dialog Box

[DEI]

I have an Access database in a multi-user environment and occasionally, the
database gets stuck in a locked state. Ex. any attempt to add a record or
update an existing record produces a dialog box with the following message:

“Could not update; currently lockedâ€

What are the conditiions that would produce this message or cause the
database to be locked? IS there a conflict between users accessing the same
record? Has someone left a table in a 'dirty' state?

Thanks in advance

DEI

 

[NAS]

I have the same issue in my work place. Unfortunately I dont know what causes
it and the solution can vary from deleting the locked file, to making
everyone log out of the database and restart their computers which causes a
major work stoppage.

 

[Karen]

I have the same issue in my work place. Unfortunately I dont know what causes
it and the solution can vary from deleting the locked file, to making
everyone log out of the database and restart their computers which causesa
major work stoppage.









- Show quoted text -

I have the same problem. On mine, the user gets the error message when
clicking in a new record on a continuous form, before they even enter
any data. So it doesn't seem like there is a valid conflict, since no
one should be "sharing" a new record. And this is when just one form
is open at the user's desktop, so there should be no conflict at their
own workstation.

Additional info: the database is split, front end and back end. Front
end resides locally at each desktop (front.mde), back end is
tables.mdb shared on the server. Source table has default value on
RecordDate field of Date(). Form on front end has default value on Who
field of Login Name.