Cannot open a password protected access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am unable to open a password protected Access Database programtically.

I have office 2003 installed on my machine.
I am using the OleDb namespace in C#.
I can open the database in access.
I can open the database programatically if I remove the password.

Here are the last 3 connection strings I've tried, with the Execption text
that was generated for them.
 
Sorry, I must of forgotten to paste the connection strings.


Connection String:
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.mdb;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;
Exception: Could not find installable ISAM.

Connection String:
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.mdb;Jet
OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;Persist Security
Info=True;
Exception: Could not find installable ISAM.

Connection String:
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.mdb;User
ID=Admin;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;Persist
Security Info=True;
Exception: Could not find installable ISAM.
 
John said:
Sorry, I must of forgotten to paste the connection strings.


Connection String:
Click to expand...
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.m
db;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;
Exception: Could not find installable ISAM.

Connection String:
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.m
db;Jet
OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;Persist Security
Info=True;
Exception: Could not find installable ISAM.

Connection String:
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.m
db;User
ID=Admin;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;Persist
Security Info=True;
Exception: Could not find installable ISAM.
Click to expand...

I think you should be able to find the right syntax here:
http://www.connectionstrings.com/

/Fredrik
 
Fredrik Wahlgren said:
Provider=Microsoft.Jet.OLEDB.4.0;C:\dev\src\pjax\RoadPay\DataFiles\roadpay.m
db;Jet OLEDB:Engine Type=5;Jet OLEDB:Database Password=mud;

I think you should be able to find the right syntax here:
http://www.connectionstrings.com/

/Fredrik
Click to expand...

I swear I thought i tried that.
Guess not cause it worked.
Thanks man, your a life saver.

-John
 
Back
Top