I have an Access database that has 15 users. Front end local to their
machine, back end on a server. Users enter/update data through forms.
Periodically there have been a few users that get a "Could not update;
currently locked. (error 3218)" error. This error once they receive it
will
repeat, not letting them enter records even after exiting the application
and
going back in. Some of the time the ldb file doesn’t release.
Couple of solutions have got them going again:
1) All users logging out, then back in,
2) Compact and repair after 1 if 1 didn't work.
These users don't update, or even have access to each other's information,
so I don't know why it would lock. Also, I don't understand why after
getting this message, which would appear to be a record lock type of
situation, would it not allow entry after closing the form and going back
in.
It locks the user up for good.
The only thing I can think of is that two users are attempting to enter a
record at the same time and the autonumber primary key is trying to create
the same thing twice?
Any suggestions or information on what could be causing this and what the
solution would be?
|
