By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,675 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

Errors Sharing 2000 DB

P: n/a
Have a small location where they share an Access Database among 4
people. It has been running in Access 97 for years. They were using
Office 2000 for everything else but Access. I wanted to get them all
on one version so I upgraded the Access and converted the database to
2000 (after making a copy). I can have several users use it at the
same time but other times I can't and have not been able to track down
what is triggering the error.

The error says "The database has been placed in a state by user
'username' on machine 'machinename' that prevents it from being opened
or locked."

Looked it up at Microsoft and the only thing they had was to update to
Service Pack 1. I started at SP1 and am now on SP3.

When the user named in the error exits the other users can get in and
the original user can get back in. Works for a while then somebody
tries to get in and they get the error. The user named in the error is
not always the same one.

I have looked at each PC and they all are set to Open Shared by default
in options.

I have hunted on the web and saw mention of splitting the database,
each user gets a front end and they all point to the data. It would be
easier just to go back to the 97 version that worked fine. Thanks in
advance!

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.