Error: The database has benn placed in a state by........

P

Patty G.

I have an Access 2000 database. When the database is opened in Access 2003
and then I try to open it simultaneously in 2000, I get the message: "The
database has been placed in a state by user Admin on machine "XXXXX" that
prevents it from being opened or locked.

If I reverse the process and open the database in 2000 and then
simultaneously try to open it on the 2003 machine it opens fine.

How do I fix this problem?????
 
G

Gina Whipp

Look under Tools... Options... Advanced... and make sure the database
Default Opening Mode is set to shared.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error: The database has been placed in a state..... 1
Access Lock File .LACCDB / Now shows as a notepad file 0
Access database placed in a state... 2
Runtime error 3734 1
ACCESS 2003 SP3: "The database has been placed in a state by user 4
database is placed in a state in access 2007 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Resolve 'Passive/Shutdown connection ' error message. 1

Top