VB and Access

[Chris Huddle]

Does anyone know how to, in VB 6.0, programatically set a password for an
Access Database, preferably in ADO? Thanks! - Chris

 

[Douglas J. Steele]

Check
http://msdn.microsoft.com/library/en-us/dnacc2k2/html/odc_acsecurity.asp

However, be aware of what it says in section 45 of the Access Security FAQ
( http://support.microsoft.com/support/access/content/secfaq.asp )

"Although ADOX (ADO Extensions for Data Definition and Security) is supposed
to have functional parity with DAO, it falls far short when it comes to
security. Many features simply don't work, such as assigning permissions to
Access objects (forms, and reports) and creating new users. Stick with DAO
when you need to programmatically manage security."

Use the NewPassword method of the User object in DAO.