Database Password

[Guest_imported]

I'm trying to open a database secured by a password with an ASP page

The database, without a password, opens with the code shown below:

'Create a connection object
Set Conn = Server.CreateObject("ADODB.Connection&quot

'Select provider
Conn.Provider = "Microsoft.Jet.OLEDB.4.0"

'Select data source - the Kingswood database.
Conn.ConnectionString = "Data Source=" & Server.MapPath ("kingswood.mdb&quot

'Open the connection
Conn.Open

How do I modify this code to open the database when it has a password?

 

[link9]

Conn.ConnectionString = "Data Source=" & Server.MapPath ("kingswood.mdb&quot & ";UID=userID;PWD=password"

 

[Ovatvvon]

You don't have to have the UID in there just to clearify. You can have just the PWD for the Database.

Conn.ConnectionString = "Data Source=" & server.mappath("kingswood.mdb&quot & ";PWD=myDatabasePassword;"

-Ovatvvon