How to install a file in app data in setup project (C#)

Question

I want to install my database to a separate folder (@ C:\Users\User1\AppData\Roaming\Company1\database.mdb)

I'm using a C# setup project.

How can I do it?

Answer 1

1. Right-click on the project and select View -> File System
2. in the new File System screen, right-click the root node (File System on target Machine) and select Add Special Folder -> User's Application Data Folder
3. Select the newly added folder form the treeview and create any sub-folder structure you need
4. Finally select your destination folder, right-click, Add -> File and select the .mddb file.