Connecting to an Access 2007 DB that is password secured

N

Ngaire

I am trying to connect to a password secured access 2007 database from an asp
page using the folloowing string

dbconn=New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="
& Server.Mappath("\fpdb\ContactDetailsP.accdb")&";Jet OLEDB:Database
Password=test;")

The password is correct - I can open the DB directly using it but this
connection fails with a password incorrect error. Any thoughts.

I tried removing the password and the connection string works fine.
Therefore I am presuming their is something wrong with the manner I can
passing the password or I need a User ID (which you do not set up in Access
2007)
 

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

Similar Threads

Exporting data with vba from Excel to an Access 2007 db with password 8
Weird Behavior on connecting 0
Connection string to Access 2007 0
Connection String to Secured Database 2
Excel 2007 ADO Connection Error 0
Application close the connection and leaves the MDB without passwo 0
Access 2007 - Changing the DB password in Runtime 0
ADO connection to a protected workbook? 3

Top