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" <(E-Mail Removed)> wrote in message
news:8C332F77-BE26-4D19-8DFD-(E-Mail Removed)...
>
> 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.

--
Joan Wild
Microsoft Access MVP

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.


"Joan Wild" wrote:

> "Len" <(E-Mail Removed)> wrote in message
> news:8C332F77-BE26-4D19-8DFD-(E-Mail Removed)...
> >
> > 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.
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>