Would the connection string for a virtual path connection look like:



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

Server.MapPath("dbfilename")



by any chance?

Or would I still need the "Jet OLEDB:Database Password=PasswordHere;" ?



--KC



> strConnect = _

>     "Provider=Microsoft.Jet.OLEDB.4.0;" & _

>     "Data Source=c:\databases\db1.mdb;" & _

>     "Jet OLEDB:Database Password=PasswordHere;"

> 

> Cheers

> Ken

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> ----- Original Message -----

> From: "Chris Nail" <shoultsc@p...>

> To: "ASP Database Setup" <asp_database_setup@p...>

> Sent: Wednesday, July 11, 2001 8:27 PM

> Subject: [asp_database_setup] Can't open Access database using ASP

> 

> 

> : I'm using Microsoft Access 2002 (and occasionally Access 2000).

> : I created a database with several tables, and set a database password 

by

> : going to Tools... Security... Set Database Password.  I haven't played

> : with any other security settings.

> : When I click to open my Access database, it prompts me for a password 

and

> : opens fine.  I obviously have the right password.  However, I'm not 

able

> : to write a connection string for my ASP page that works.  If I remove 

the

> : database password, everything works perfectly.

> : Here's what I'm using:

> 

> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: <k_c@p...>

Subject: [asp_database_setup] Re: Can't open Access database using ASP





: Would the connection string for a virtual path connection look like:

: 

: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & 

: Server.MapPath("dbfilename")

: 

: by any chance?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Yes



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

: Or would I still need the "Jet OLEDB:Database Password=PasswordHere;" ?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Depends if you have a password on your database or not.



Cheers

Ken