MS Access password protected database vs C#

[Mr. Tomaszek]

Hi all,
I have a password protected MS Access database. I can easyly open it under MS Access application. Alas, when I trying to access this database using DataAdapter in VS2003/C# I get error message that initialization of provider was failed. There is no error when database isn't password protected.

Can I use OLEDbDataAdapter to connect to password protected MS Access database.

How can I check a user name (VS by default uses 'Admin' - but there is no user option while I'm setting password in MS Access) of my database - maybe this is the problem?

Big thanx in advance.

[mmetzger]

Take a look at

http://www.connectionstrings.com/

Look under the Access for OleDb and it should give you an example of how to handle a password protected db.

[Mr. Tomaszek]

Thank you. :thumb: