Connect to a password protected Access database!!

[John Kh]

Is there a good way to connect to a password protected Access databse usig VB.Net? I tried some of those but it is still giving me errors!! "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatabase.mdw;" "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="

[Kschuler]

I use an OLEDB connection with this connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; If you are looking for more connection string options this [^]is a great site. Hope this helps.

[emimmortal]

may be work with Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=PWD;Data Source=C:\mydatabase.mdb;Persist Security Info=False

Emimmortal

[John Kh]

Thank you all for replying. It was a great help to try diffrent methods. John,