connect yo database access with password

[Guest]

hi !
how i can connect to my database in ASP only with password
i connect to my database like this:
dim conn,SQLstr,rs
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
DSNName = "DRIVER=Microsoft Access Driver (*.mdb);DBQ="
DSNName = DSNName & Server.MapPath("/ts_egged/db1.mdb")

 

[Douglas J. Steele]

Try:

DSNName = "Provider=Microsoft.Jet.OLEDB.4.0;;" & _
"Data Source=" & Server.MapPath("/ts_egged/db1.mdb") & _
";Jet OLEDBatabase Password=MyDbPassword"

(replace MyDbPassword with whatever's appropriate)