connect yo database access with password

  • Thread starter Thread starter Guest
  • Start date Start date
G

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")
 
Try:

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

(replace MyDbPassword with whatever's appropriate)
 
Back
Top