Can't set db password for exclusive mode

T

Tim Cali

I attempt to set the database password for an exclusively-opened database in
Access 2000, and I continue to get the message that I must first open the db
in exclusive mode (which it is).

Why is that and how to I set the db password?
 
J

Joan Wild

How are you opening it exclusively? You should
1. Open Access
2. File, Open
3. Select the mdb
4. in the lower right of the Open dialog, click the drop-down and choose
Open Exclusively.
 
J

Joan Wild

Is this database secured using user/password security as well? If so, you
need administer permissions to set the password.

If that's not it, try opening it exclusively via a shortcut.
"path to msaccess.exe" "path to mdb" /excl
 
T

Tim Cali

Is this database secured using user/password security as well? If so, you
need administer permissions to set the password.
Click to expand...

No, it's not.

I think I got it though..I went to Tools -> Options and set the default open
mode to "Exclusive". Closed/reopened. Reset it to "Shared", closed.

Then I opened it exclusively and it worked! I guess doing that
"jump-started" something somewhere.

Don't have a clue why.
 
Top