set database password when converting AC00 to AC07

[Stanley L.]

I am converting a AC 2000 to AC 2007 and am opening the database in 2007
format. I have a 2000 custom menu choice to set a DB password. When clicking
that in AC 2007, I am advised to open the db in Exclusive mode when it is
already open in exclusive mode. I have verified exclusive mode in the
immediate window by getting a value of 1 when asking Open Mode =
Application.GetOption("Default Open Mode for Databases"). Also the AC07
options this database are set to open in exclusive mode.

Why won't AC2007 allow the setting of a DB password but instead tells me to
open the DB in exclusive mode when it alresdy is open in that mode?

 

[Chris O'C via AccessMonster.com]

Reading that db option only tells you what the setting is, not whether the db
was opened exclusively. If the locking file is already open when you try to
open the db exclusively, the db will open in shared mode, no matter what your
settings are.

To guarantee opening in exclusive mode use a shortcut with the /excl switch.

"path to msaccess.exe" "path to db.accdb" /excl

After you open the db exclusively with the shortcut, change your password.

Chris
Microsoft MVP

 

[Stanley L.]

Thank you very much Chris. It worked as you said. I owe you a beer!
Stan