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 OLEDBatabase
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
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 OLEDBatabase
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