setup project

Question

Hi in my project I have MS Access database. I also made setup project and I want access file to be copied on drive c: during installation process. How to do it?

Dozd · Answer

1. Access database i not included in my project. If I include it in project adapter.update() method does not work! The code is same but it works only if access database is outside of the project. If somebody has solution about this problem please help me. I spend a lot of time to find solutions about this problem. 2. Yes I know about option to add->file but during installation database file copies in installation directory so the exception appears because in code in connection string the path is e.g c:\mydadabase.mbd

Scott Knake · Answer

Is the access database included in your project? On your deployment project right click on it and select View -- File system then select Application Folder on the left side. On the right side select Add -- File and add the local path to the resource to be copied. It will embed the file in the installation media and copy it when the product is installed