Changing database password

[Len]

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.

 

[Joan Wild]

I've got the message:

"Cannot change password on shared open database"

A user needs to have the mdb opened exclusively in order to change the
database password.

 

[Len]

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.