Is it possible to access an ACCESS DB with password protected?

[ZhangZQ]

Is it possible to access an ACCESS DB with password protected?
I have the user/password information of an access db, how can I access it by
System.Data.OleDb ?

Another question is, is it possible to compact a access db by a
System.Data.OleDb ?


Thank you very much!
ZhangZQ

 

[Chris Mayers]

username/password goes as part of the connection string when attempting to
access password protected database.
Off the top of my head:
.....User Id = <username>;password=<password>....

Not sure about compacting an Access DB, that is a specific Access function,
rather than an OleDb one...

Chris

 

[W.G. Ryan eMVP]

Chris answered the first part of your question - here's the answer to the
second part http://www.knowdotnet.com/articles/compactmdb.html

 

[ZhangZQ]

Thank you very much!