I'm creating a standalone windows application which will create and store invoices. It will use an embedded, local MS Access db as the datastore.
I have included the db in the VB .Net project and created the connection string to it. The path is:
C:Documents and Settingsdigbd0My DocumentsVisual Studio 2005ProjectsInvoiceGeneratorTimeExpenses.mdb
When I build the project it outputs everything to the bin folder:
C:Documents and Settingsdigbd0My DocumentsVisual Studio 2005ProjectsInvoiceGeneratorinTimeExpenses.mdb
This is then a different path to the database so any inserts, updates etc take place on this copy of the db.
When I want to distribute the solution to a user (it is only a single user application so the db is not shared) how should I code the connection string so the path is not hardcoded as above and points to the location in which the database is installed?