Querying a passworded DB

[blacksaibot]

I set up my MS Access 2007 database with a password.

I've written a program in VB.NET to communicate with the database. However, now that it's been passworded, obviously the queries don't work.

What do I have to add in my program to access the database?

Would I have to put it somewhere in the line I instantiate my connection with OleDBConnection

("Provider=Micorsoft.jet.oledb.4.0;data source=") etc. etc. ?

 

[boblarson]

Check out http://www.connectionstrings.com for the applicable connection string to use in order to pass a database password.