ADO with password protected Databases

[WandaB]

Does anyone know how to use the ado data control with a password protected database. I have used the connection string wizard to create the connection and entered the password but the control will not authenticate to the database. If I remove the password it works fine. I have tried the Microsoft jet 3.15 and 4.0 ole db.

[michelle]

Hello WandaB,


Try this source:

Set ProjectsDB = OpenDatabase(DbSettings, True, False, ";pwd=YourPassword")


To change your password:

ProjectsDB.NewPassword "OldPassWord", "NewPassWord")


Good luck,

Michelle.

[Chris]

Hi WandaB, I think this what you looking for...

Assume SysDb is you database filepath.

Dim MyConn as ADODB.Connection
Dim SysDB$
Set MyConn = New Connection
With MyConn
    .Provider = "Microsoft.Jet.OLEDB.4.0"
    .ConnectionString = "Data Source=" & SysDB & "; Jet OLEDB:Database Password= <Your Password>"
    .Mode = adModeReadWrite
    .Open
End With