CodeItBetter Programming Another VB Programming Blog

How to open a password protected Access database using ADO.

Posted on August 5, 2011
1
2
3
4
5
6
7
8
'Database - How to open a password protected Access database using ADO.
Dim conn as ADODB.Connection
 
Set conn = New ADODB.Connection
conn.Provider = "Microsoft Jet 4.0 OLE DB Provider"
conn.ConnectionString = "Data Source=" & Server.Mappath("\path\your_database.mdb")
conn.Properties("Jet OLEDB:Database Password") = "your_password"
conn.Open
Filed under: Database Leave a comment
Comments (0) Trackbacks (0)

No comments yet.


Leave a comment


 

No trackbacks yet.