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

Y

ychwang

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".
 
Y

ychwang

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.
 
S

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.
 
T

Tony Toews

ychwang said:
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".
Click to expand...

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
 
Top