Hi Erik,

Article "Migrating from DAO to ADO" posted http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate_topic4.asp?FRAME=true#daotoadoupdate_topic4c has several examples on opening Secured Microsoft Jet Databases [Password Protected Databases and Databases with User-Level Security].

Here is an axample for password protected database:

ADO

Sub ADOOpenDBPasswordDatabase()

Dim cnn As New ADODB.Connection

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=.\NorthWind.mdb;" & _
"Jet OLEDB:Database Password=password;"
cnn.Close

End Sub

HTH, Igor