Connection string to Access 2007

J

JBA

My asp (active server pages) file communicates with an Access database on a
server that runs on IIS . The database is saved to the Access 2003 format
and the connection from the asp page to the database is always successful.
But if I try to connect to an Access 2007 database, I encounter a problem.

I can connect if the 2007 database has no password. I use this connectiong
string in the asp file:

strConn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &
Server.MapPath(".") & "\test_database.accdb;Persist Security Info=False;"

If I encrypt the database with a password, the appropriate connection string
becomes:

strConn="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &
Server.MapPath(".") & "\test_database.accdb;Jet OLEDB:Database
Password=mypassword;"

Now when I try to connect, I get the message: "The page cannot be
displayed" and one of the error types listed is "Not a valid password"

The source of the connection strings, ConnectionStrings.com, suggests that
the password should be set using the Set Database Password function in
Access. But, I can find no documentation on this function.

Has anyone else faced this issue?

Thanks.

Jim
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top