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.

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.
 

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

Top