Password protected Access Database 1

[fischadler]

I am using the code below to access an Access database:

set Con = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=DSNtemp & "DBQ=" & server.mappath("mydb.mdb")
Con.Open DSNtemp

What should I add to this code if the database is password protected?

Thanks

 

[Lothario]

Something like this:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=" & Server.MapPath(".") & "\myDb.mdb;" & _
"Uid=admin;" & _
"Pwd=gdfgdfg"

-L

 

[fischadler]

Thanks!