Passwords to an Access Database!!

[CooterBrown]

Hi
I am trying to access a password protected Access DB with ASP and I want to know if anyone can tell me when I need to put the password in my script? Can someone help? My code is below. thanks in advance!!

CooterBrown


set OBJdbConnection=server.createObject("adodb.connection&quot
strProvider="driver=Microsoft Access Driver (*.mdb); DBQ=" &_
server.mappath("../database/DB.mdb&quot & ";"
OBJdbConnection.open StrProvider

set rsList = server.createObject("adodb.recordset&quot

rslist.activeconnection = OBJdbConnection
rslist.source= "SalutesToAmerica"
rslist.open

 

[lobstah]

"Driver={Microsoft Access Driver (*.mdb)};" &_
"Dbq=\DBase\DBase.mdb;" &_
"Uid=Admin;" &_
"Pwd=MyPassword;"

so you would add it to the end of your:

strProvider="driver=Microsoft Access Driver (*.mdb); DBQ=" &_
server.mappath("../database/DB.mdb&quot & ";" &_
"Uid=Admin;" &_
"Pwd=MyPassword;"

 

[jonscott8]

strProvider="driver=Microsoft Access Driver (*.mdb); DBQ=" & server.mappath("../database/DB.mdb&quot & ";" & "Uid=Admin;Pwd=" & cPassword & ";" Jon Hawkins

 

[jonscott8]

or

OBJdbConnection.open StrProvider,"Admin","Password" Jon Hawkins