Cannot open a password protected access database

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.

John
Thu Mar 10 11:09:14 CST 2005

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.

Fredrik
Thu Mar 10 11:17:47 CST 2005


"John" <John@discussions.microsoft.com> wrote in message
news:82878969-662E-401F-99D2-F2295186EB2A@microsoft.com...
> 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 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.
>
>

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

/Fredrik

John
Thu Mar 10 11:37:07 CST 2005



"Fredrik Wahlgren" wrote:

>
> "John" <John@discussions.microsoft.com> wrote in message
> news:82878969-662E-401F-99D2-F2295186EB2A@microsoft.com...
> > 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 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.
> >
> >
>
> 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