How to access an MS access database which has been set up password?

[J. Su]

Hi,

I want to use C# to access an MS Access database which has been setup a
password by using Set Database Password in Microsoft Access application. How
can I do it? Please help!

Thank for your help.

Z. Su

 

[Rob Windsor [MVP]]

Add "Jet OLEDBatabase Password=<insert your password>" to your connection
string.

 

[Nicole Calinoiu]

If you're using the OleDb data provider, a connection string in the
following form should do the trick:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path to MDB file>;Jet
OLEDBatabase Password=<the database password>

See http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefjetprovspec.asp
for additional connection parameters specific to the Jet OLE DB provider.

HTH,
Nicole