Password Change

[mommedic]

I have an established database program. There is a single password templete
that will allow you to make changes, and will also allow you to change that
password. The database also has a second level security password. I know
this password, however I would like to change it. There is no popup box that
allows you to change this password. I beleive it was set by the creator of
the database, however this password has become general knowledge.
Any suggestions?????

 

[Krzysztof Pozorek [MVP]]

(...)

password. The database also has a second level security password. I know
this password, however I would like to change it. There is no popup box
that
allows you to change this password. I beleive it was set by the creator
of
the database, however this password has become general knowledge.
Any suggestions?????

Do you have your password database mean? If so, then You can do this in that
way:

Set nDb = DBEngine.OpenDatabase("C:\Db1.mdb", -1, 0, ";pwd=old_pass")
'Set nDb = CurrentDb '<- In this case db must be open exclusively.
nDb.NewPassword "old_pass", "new_pass"
nDb.Close
Set nDb = Nothing

K.P.