jmss66

I have an ACCESS password protected database I am constantly getting an invalid password error message. What is it I am missing? Below is my ADO Connection string. Any assistance will help.

Thanks,
Judy

Dim objConn
curDir = Server.MapPath("db/HFPension.mdb")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & curDir & ";Persist Security Info=False;Jet OLEDBatabase Password=" & xerox

rahamad

Here's what I use and it works:

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

Keep in mind this only works for a regular password-protected database. If you are using a workgroup security file, the way to pass in the info is different.

jmss66

I did try your connection string. I took out the Persist security info since this is the only thing different between you connection string and mine. I still get the error message invalid password. I swear I did not do a typo on the password. I still do not understand why it is working for you when I even copied your connection string to my program so there won't be any typing error.

Thanks,
Judy

jmss66

Quote:

---

Originally Posted by jmss66
I did try your connection string. I took out the Persist security info since this is the only thing different between you connection string and mine. I still get the error message invalid password. I swear I did not do a typo on the password. I still do not understand why it is working for you when I even copied your connection string to my program so there won't be any typing error.

Thanks,
Judy

---

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.