Can't set db password for exclusive mode

  • Thread starter Thread starter Tim Cali
  • Start date Start date
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?
 
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.
 
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
 
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.
 
Back
Top