• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Open a password protected Access data file using ADO code

Open a password protected Access data file using ADO code

Open a password protected Access data file using ADO code

API Declarations


Dim cn As New ADODB.Connection, strCNString As String



Rate Open a password protected Access data file using ADO code

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

strCNString = "Data Source=" & App.Path & "\BB.mdb"
cn.Provider = "Microsoft Jet 4.0 OLE DB Provider"
cn.ConnectionString = strCNString
cn.Properties("Jet OLEDB:Database Password") = "aaa"
cn.Open

MsgBox "Data File is now opened"

cn.Close


End Sub


Private Sub OptionA()

cn.Open "Provider=Microsoft Jet 4.0 OLE DB Provider;Data Source=" & App.Path & "\BB.mdb" & ";Jet " _
    & "OLEDB:Database Password=aaa"
MsgBox "Data File is now opened"
cn.Close

End Sub