I have a problem and I am unsure how to go about it. I am creating a simple vb.net program that uses MS Access as a backend. I place the database in c:\data\data.mdb. In the visual basic designer on one of the forms, I have a odbcconnection object where inside the connectionstring property it points to the database on my machine. I then have controls that look toward a command object which in turns looks through the connection object.

My problem is, what if I package the program up and gave it to someone else to install. The database on thier computer will not be in c:\data\data.mdb. Therefore the connectionstring in the command object is incorrect because the connectionstring is based where I had the database and not where it is on the users machine.

How do you go about creating a program where multiple individuals will install the program and you have to adjust the connectionstring to where the database is on thier computer?