My project has a ms Access database which has which has been added as data source in the root of my project. The properties set: Build Action �Content and Copy to output directory �Do Not Copy.

My problem is: when deployed using SetUp project .msi the database is visible in its original state in the deployed folder.

SetUp dependences include: Content file from MySetup (active) �Primary output from MySetup (active) �XML Serialization assemblies from MySetup (active) Although I can protect the DB with password it’s more secure to not visible.

There is no problem using ClickOnce. Have I missed a configuration?

hemo

Hi Hemo,

You can install the Access database file to the user's Application Data Folder rather than the target installation directory where the executable is installed. Open the Setup project. In the File System view, add the "User's Application Data Folder" under the File System on Target Machine and move the database file to this Application Data Folder.

Hope this helps.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.

Hi Hemo,

> when deployed using SetUp project .msi the database is visible in its original state in the deployed folder.

Do you mean that the database file is installed on the target machine? The MS Access database is a file-based database, so the Access database file must be installed on the target machine for the application to retrieve data from it.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.

Hello Linda

Yes my query is that the database on the target PC is accessibly.

Is password protection the only method to preserve integrity ?

Regards

hemo

Hi Hemo,

You can install the Access database file to the user's Application Data Folder rather than the target installation directory where the executable is installed. Open the Setup project. In the File System view, add the "User's Application Data Folder" under the File System on Target Machine and move the database file to this Application Data Folder.

Hope this helps.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.

hello Linda