The database has been placed in a state by user....

[Annie]

Hi,
I am not a Access expert so maybe one of you can help me.

Here is the situation:
We a simple ACCESS application (couple of tables, 2
forms). When a usager enter this database
and press the "save" button, the database becomes
unaccessible. We get this message when we
try to access it: "The database has been placed in a state
by user XXXX on machine XXXX that prevents
it from being opened or locked". The user did not place
the database in exclusive mode. Is this behavior normal
or is this a bug that can be corrected?

Thanks in advance.

 

[Van T. Dinh]

It sounds like there are corruptions in your database.

See Tony Toews' set of articles:

<http://www.granite.ab.ca/access/corruptmdbs.htm>

HTH
Van T. Dinh
MVP (Access)

 

[Annie]

Hi,
I tried all those solutions and it didn't correct the
problem. I even try creating a new database and exporting
all the objects one by one and the error is still there.
I am starting to think that this behavior is normal??

 

[Van T. Dinh]

It is definitely not normal behaviour.

See if any of the following articles help:

http://support.microsoft.com/?id=248967

http://support.microsoft.com/?id=274211

http://support.microsoft.com/?id=248936

http://support.microsoft.com/?id=247180