Microsoft Access 2003 "the database has been placed in a state by.

[Guest]

We have a shared Microsoft Access 2003 .mdb database that is located on a
network drive. Ocasionally we encounter the message "the database has been
placed in a state by user...the prevents it from being opened or locked".

 

[Joseph Meehan]

We have a shared Microsoft Access 2003 .mdb database that is located
on a network drive. Ocasionally we encounter the message "the
database has been placed in a state by user...the prevents it from
being opened or locked".

It sounds like someone is opening it exclusively. It may take some
detective work to find out who. They may not even know it themselves. It
makes me wonder if you have a split database or not? If not, maybe you
should.

 

[Guest]

Thanks Joseph.

All of our users are in the "shared" mode. Our database is not yet splitted,
but I'm not sure this problem is caused by that, could you comment? Thanks.

 

[Sergey Poberezovskiy]

I noticed that when someone makes a change to either a
module or opens a form/report in a design view it can
place the database in "exclusive" mode.

HTH.

 

[Tony Toews]

We have a shared Microsoft Access 2003 .mdb database that is located on a
network drive. Ocasionally we encounter the message "the database has been
placed in a state by user...the prevents it from being opened or locked".

This can be a sign of corruption.

For more information on corruption including possible causes,
determining the offending PC, retrieving your data, links, official MS
KB articles and a list of vendors who state they can fix corruption
see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm