Search code examples
c#ms-accessms-access-2007connection-string

how to open access database with password in C#?

how can I open an MS Access 2007 database with a password in c# ?

I have tried this: Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\BioDB.mdb ;Password=1966;");

but it doesn't work.

Solution 
  • Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;

    From:

    http://www.connectionstrings.com/access

    And as noted below use @.