database is placed in a state in access 2007

T

Tsega

Hi I have a shared database with 5 people that was working well with Access
2003. When we switched to Access 2007, the below error was encountered by the
third person who was trying to log in using Access 2007. At that point, 2
people were using Access 2007 and 2 others Access 2003 sharing the same
database. For the third person to log in, one of the users (X) had to log off
and let the third person log in. After the third person logged in, user (X)
was able to log in. Can anyone help me why the below error might be coming
up? Thanks!

The database has been placed in a state by user "Admin" on machine "X" that
prevents it from being opened or locked.
 
T

Tom van Stiphout

On Tue, 22 Sep 2009 13:48:07 -0700, Tsega

"Using the same database"?
It is VERY IMPORTANT that you give each user their own copy of the
(front-end of the) database, all connecting to the same back-end. This
is the #1 FAQ so you should have no trouble finding relevant resources
online. Keywords: split access database
Also check out Tony Toews Updater utility. Also easy to find via
Google.

-Tom.
Microsoft Access MVP
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access database placed in a state... 2
Access 2007 running Access 2000 database - user level security 2
Error 3033 / Conversion from Access 2003 to Access 2007 0
Set password for groups 2
Database has been placed in a state by user 0
Error 3734 - Database is locked 1
ACCESS 2003 SP3: "The database has been placed in a state by user 4

Top