Changing database password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a form allowing user to change database password in the Access
2002 application. When running the following statement

db.NewPassword CurrentPassword, NewPassword

I've got the message:

"Cannot change password on shared open database"

What can be wrong?
Thanks.
 
Len said:
I've got the message:

"Cannot change password on shared open database"
Click to expand...


A user needs to have the mdb opened exclusively in order to change the
database password.
 
When I select the File/Open menu choice and click the Open button, the Open
Exclusive option is already check marked. So, I just select this option
expecting that database will be opened exclusively. Nevertheless, I am not
able to change the password.

By the way, I am able to compact the opened database, which requires the
database to be opened exclusively as well.
 
Back
Top