How to change the database password using VBA code? 1

[sandman2869]

Hi all,
I am currently working on a project with access 97 and I want to be able to change the database password (old password being provided) using code. I am hoping that someone will be able to help me as I am VERY new to access and all help is appreciated.


Thanks in advance,

Leon

 

[tomschafer]

Try this...

Dim db As Database

Set db = OpenDatabase("c:\directory\dbname.mdb&quot

db.NewPassword "OldPassword", "NewPassword"

 

[sandman2869]

Pezamystik,
Thank you, the code works perfectly
You wouldn't also happen to know how to create a user account would you? If not, I appreciate the great help you have already provided.


Thanks again,


Leon

 

[tomschafer]

Look in help under CreateUser Method.