Unable to open any Access database exclusively and set/change pass

G

Guest

System:
MS Windows 2000 Pro, SP4
MS Access 2000, SP3

Problem:
I am unable to open any .mdb file exclusively and set/change the database
password. For example, I opened Access, created a new database on my local
drive called "db1.mdb", closed Access, reopened Access, opened "db1.mdb" via
the File menu using "Open Exclusive" option, selected Tools->Security->Set
Database Password..., entered a password, and got the following error message:
"You need to have the database open for exclusive use to set or unset the
database password..."

This started a while ago on databases I wrote and administered for years.
I've avoided doing any security changes because all of my attempts at finding
a solution to this problem have only resulted in wasted time. Please help.
 
G

Guest

I've had the similar problem. The source of the problem in my case was in the
Tools/Options/Advanced settings where the default open mode was set to
Exclusive. The resolution was to change this setting to Shared.

Len
 

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

Cannot unset the db password 3
Open exclusively with shell 1
set database password when converting AC00 to AC07 1
Access 2007 open mdb (2000) file read-only 9
set database password 1
Add myself to the administrators group, open the db exclusively 1
can't log in to any of my databases 4
Password Activated Although Never Set 2

Top