Connecting to MS Access with Tools Box Data Connection with a Password

[jangidbs]

I want to connect to MS Access using Data connection from tool box. The database is password protected. How can i do. Help is required.

Madan Jangid

 

[jmcilhinney]

The "Start VB.NET" tutorial in my signature has a section on ADO.NET and a subsection on Access. I suggest that you take a look. Also, www.connectionstrings.com has details of a large number of connection string formats.

 

[cjard]

bear in mind that the password used to secure an acccess database is not passed in the "password=" section of a connection string. That section (user/password) is reserved for MDW secured databases. Instead, the Jet OLEDBatabase Password attribute is used. Bear this in mind when reviewing your connection string.