My project has an access database, I have added the database via 'Add New Data Source' into my project and DatSet.xsd. I am trying to add a password to protect it when installed using SetUp.msi on the clients machine. I have entered a password in the Add Connection dialog box but when installed on the clients machine the database is not protected.

Help would be appreciated.

latoc

Hi latoc,

My suggestion is just like part of what you have done. You can store the password in the config file. Not in the connectionstring. Add another node to the config xml, for example, named password. When you load your application, check that node value, if it is empty, popup a dialog let your user to input password. Then store it in that node's value field. Build your real connection string in the code put the password into that string.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

I have found a solution but would be grateful for advice to its correctness.

Set Password in the Database > select Add New Data Source > Add Connection > Set Password.

Connection String "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = |DataDirectory|\MyData.mdb;Jet OLEDB:Database Password=1234;"

latoc

Hi latoc,

My suggestion is just like part of what you have done. You can store the password in the config file. Not in the connectionstring. Add another node to the config xml, for example, named password. When you load your application, check that node value, if it is empty, popup a dialog let your user to input password. Then store it in that node's value field. Build your real connection string in the code put the password into that string.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Hello Kira