Home > How-To Library > Database

How to open a password protected Access database using ADO.

****************************************************************
*       © 2007 CodeItBetter http://www.codeitbetter.com        *
*          This notice MUST stay intact for legal use          *
****************************************************************

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

If you would like to submit your code here please us. Do not forget to mention your name. We are always thankful to each and everyone of you who submitted their code here.