I have an ACCESS database which I am going to put a password. What do I need to do or add in my connection string for the password? The connection string below is working till I put a database password.


  Dim objConn
  curDir = Server.MapPath("db/MyDatabase.mdb")
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curDir

Thanks,
Judy

Try adding a password to the Admin account instead. Typically passwords are user-oriented instead of file-oriented. If you give the Admin a password, then add the following to the connection string:

User ID=Admin; Password=<password>;

Hope this helps,

Brian

Hi Brian,

I tried putting a user id and password and it didn't work. I researched on it some more and this is suppose to be the correct way of handling the connection string. The only problem is, it still does not work. I am getting an invalid password error message. I swear I did not make a mistake on typing the password. Can anyone please help.

Thanks,
Judy

  Dim objConn
  curDir = Server.MapPath("db/myDatabase.mdb")
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curDir & ";Jet OLEDB:Database Password=" & mypassword

I finally figured out what I was doing wrong. I am passing my password as a variable which I should not.

Wrong way

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myPath & ";Jet OLEDBatabase Password=" & myPassword

Correct Way

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & myPath & ";Jet OLEDBatabase Password=myPassword"

It was right in front of my eyes and it took me half a day to figure it our. Oh well...

Thanks for your help.