I'm using this connection string to open a connection to Access.

<%

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data 

Source=C:\Inetpub\wwwroot\BegASPFiles\cars\cars.mdb; Persist Security 

Info=False"

%>



It's my understanding that, if someone knew the name of the database, they 

could get access to it.  I set a password within Acess.  Now I need to 

know what syntax to use for the connection string to pass the password as 

part of the connection string.  How should the above connection string be 

modified to send the password "ModelT"?



Tim

Hi Tim,



strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data

Source=C:\Inetpub\wwwroot\BegASPFiles\cars\cars.mdb; User Id=yourUserName;

Password=yourPassword;



Ethan





-----Original Message-----

From: Tim Morgan [mailto:aviatortim@h...]

Sent: Friday, August 03, 2001 6:03 PM

To: Access ASP

Subject: [access_asp] How to pass username & password Access connect string?



I'm using this connection string to open a connection to Access.

<%

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data

Source=C:\Inetpub\wwwroot\BegASPFiles\cars\cars.mdb; Persist Security

Info=False"

%>



It's my understanding that, if someone knew the name of the database, they

could get access to it.  I set a password within Acess.  Now I need to

know what syntax to use for the connection string to pass the password as

part of the connection string.  How should the above connection string be

modified to send the password "ModelT"?



Tim