Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database placed in a state

Status
Not open for further replies.
Jan 18, 2007
39
US
Using Access 2003 and recently began receiving the message: The database has been placed in a state by user 'UserID' on machine 'PCId' that prevents it from being opened or locked.

This is a multiple user DB. The first user can log in fine, anyone after that receives this message and enters the DB in a Read Only state.

The tables are in one DB and the forms in another.

Any ideas on how to resolve this?

Thanks,
Phil
 


Hi,

Does that user have the DB opened EXCLUSIVELY?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
No, in the past many users could be in at the same time. Now this is happening. Doesn't matter who goes in first. Once someone gets in the DB, every other user gets this message and cannot get in until the user exits.
 
Did you install or update any non-Microsoft products around the time that this issue occurred?

I know this sounds odd but a couple of years ago a client of mine was experiencing a similar problem. We narrowed it down to a conflict between the then current version of Simply Accounting (accounting package) and Access. A subsequent update (about 4 months later) resolved the issue.

Hope this helps.

Please help us help you. Read Tek-Tips posting polices before posting.

Canadian members check out Tek-Tips in Canada for socializing, networking, and anything non-technical.
 
I expect the users do not have permissions to create files in the folder. After the first user opens the mdb, do you see an LDB file created in the same directory/folder?

Can every user create and delete a simple text file with notepad in the folder?

Duane
Hook'D on Access
MS Access MVP
 
I know as much about Access as I know about quantum physics - zilch. So, take this with a grain of ....salt.

I read somewhere that if you start a Blank mdb first and then open another instance of Access with the actual document, this sort of thing doesn't happen where Access promotes itself from Shared to Exclusive.

If this is completely wrong, my apologies.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents
 
To my knowledge there have been no new installs, maybe MS updates only. Maybe Adobe Reader or Java.

Users are limited but some have admin rights. Even the ones with Admin rights get the same message. As soon as someone logs in a LDB file is created.

Every user can enter/update data.

Not sure xlhelp about the Shared/Exclusive thing. I would have to research. The problem is that everything references Access 2000 and states to install the latest service packs. We are using Office 2003 with SP3.

One option I am going to try tomorrow is to open in 2007 and save as a 2003.

Anyone have any other ideas??? Thanks to you that are reading and answer my post.
 
Resolved the problem by splitting the database. What I mean by that is we copied the database itself to each users PC while the data tables(already in a different database) stayed on the network source.

Thanks to everyone for your assistance!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top