Please help -- Can not get into DataBase.

[Guest]

Hi all,

I meet a strange problem for the Access database. We have a securied
database used for a group of 20 people. It works well for a long time, but
one day, when open the database on one of the computers with the
administrator user name, then all of us get the error message like this:

The database has been placed in a state by user 'UserName' on machine
'machineName' that prevents it from being opened or locked.

But, once the database was opened on any other computer as administrator or
ready only user before that computer, then nobody (include that computer
cause the problem) is going to have any problem to get in the database. So we
had to let that computer log out off the database to let us get into the
database first.

What should I do to avoid this noise?

Thank you very much, and happy holidays!

Blinda

 

[Tony Toews]

I meet a strange problem for the Access database. We have a securied
database used for a group of 20 people. It works well for a long time, but
one day, when open the database on one of the computers with the
administrator user name, then all of us get the error message like this:

The database has been placed in a state by user 'UserName' on machine
'machineName' that prevents it from being opened or locked.

But, once the database was opened on any other computer as administrator or
ready only user before that computer, then nobody (include that computer
cause the problem) is going to have any problem to get in the database. So we
had to let that computer log out off the database to let us get into the
database first.

The user logged onto that computer doesn't have full read write
permissions to the folder, not just the file, where either the back
end MDB or MDW resides.

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

 

[Guest]

Tony,

Thank you very much for you reply. Could you please tell me what I can do
for this case?

Thank you,

Blinda

 

[Tony Toews]

Thank you very much for you reply. Could you please tell me what I can do
for this case?

You need to set the permissions for that folder for that user with
complete read/write/modify/delete privileges.

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