Cannot open a password protected access database

[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.

 

[Guest]

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 OLEDBatabase 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 OLEDBatabase 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 OLEDBatabase Password=mud;Persist
Security Info=True;
Exception: Could not find installable ISAM.

 

[Fredrik Wahlgren]

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.m
db;Jet OLEDB:Engine Type=5;Jet OLEDBatabase 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 OLEDBatabase 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 OLEDBatabase Password=mud;Persist
Security Info=True;
Exception: Could not find installable ISAM.

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

/Fredrik

 

[Guest]

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

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

/Fredrik

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

-John