MS Access Connection & Password How?

[Ginka]

I have a DB in MS Access, I have set a password to avoid being open by the end user.

Access asked me to create a .MDE File, I did it.

But when I'm trying to test the connection it says something like if I missnig something in the connection string.

Could anybody tell me how a connection string should be using a Password?

 

[dalchri]

This is what I use:

//Initialized elsewhere
string strPassword;
string strDatabaseFilename;

string strConnectionString =
   "Provider=Microsoft.Jet.OLEDB.4.0;" +
   "Data Source=" + strDatabaseFilename + ";" +
   "Jet OLEDB:Database Password=" + strPassword;

 

[roccorocks]

Just FYI guys, here is a great link for all your connection needs!

http://www.connectionstrings.com

Thanks,

Rocco