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?

 

[Stanley L.]

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