Connecting to a database password protected back end

[mbentley]

I have to create an ADO connection to a password protected backend. Not user-level security, but simple file security. How do I format the connection string to pass the password? The arguments that work for user-level security do not work.

 

[mbentley]

Solution

Figured it out:

MyConnection.Properties("Jet OLEDB:Database Password") = MyPassword