CodeItBetter Programming Another VB Programming Blog

'Database - How to Open a password-protected Access database with ADO
'The program sets the ConnectionString's "Jet OLEDB:Database Password" field to 
'the password value.

Private Sub cmdOpen_Click()
    Dim conn As ADODB.Connection
    Dim rs As ADODB.Recordset
 
    ' Open the connection.
    Set conn = New ADODB.Connection
    conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & _
        Me.txtDbName.Text & ";" & "Jet OLEDB:Database Password=" & txtPassword.Text
    conn.Open
 
    ' Get the data.
    Set rs = conn.Execute("SELECT Title FROM Books ORDER BY " & "Title")
    lstTitles.Clear
    Do While Not rs.EOF
        lstTitles.AddItem rs!Title
        rs.MoveNext
    Loop
 
    rs.Close
    conn.Close
End Sub