Removing a MS Access password using DDL

[erkle]

Is it possible to remove a MS Access database password using VB code?

 

[Junior1544]

yes it is. i don't know how, but my real question is... why? JHauge@jmjpc.net
Life is change. To deny change is to deny life.

 

[cmmrfrds]

Both DAO and ADO have methods to change password. In ADO it is changepassword and I believe in DAO it is password. You should be able to find both under the help in Access. To use ADO requires the reference to the ADOX library.

 

[erkle]

I needed to do this because having a password is causing a lot of grief on a production application when we want to make changes. Thanks for you help.