MS Access Password in ASP script

[jfs9900]

Ok I have password protected my Access database. I have ASP code that does not include in the password, I am not sure where to place it in the code - and every time it runs it comes up with an 500 internal server error message...


Here is a sample of the code:
.......................................
dim Conn, rs
set adoCn=server.createobject("ADODB.Connection")
adoCn.open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;Data Source=" & server.mappath("fpdb/database.mdb")
set rs=createobject("adodb.recordset")
.......................................

database.mdb is the password protected file, lets just say ABCD is the password.... how should it look?

 

[Lothario]

Something like this:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDBatabase Password=MyDbPassword", _
"myUsername", "myPassword"

for more information visit the below link...

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

-L