Help please - installing to selected locations

I am trying to set up an installation routine that will allow the user to select the location to install both the program and the database that goes with the program.

I have been writing and testing with a predefined ADO Connection and would like to have it variable so the user can select the drive to install the program [C:] or [D:] etc.

First I need some help with setting up the way I have my ADO connection written. This is what I have:

Set adoconn = New Connection
adoconn.Open _
"PROVIDER=Microsoft.Jet.OLEDB.4.0;Data " & _
"Source=C:\project1.mdb;"


How can I modify this so that the project1.mdb is a variable location with the database name being constant ?? or is there a way to set this up so the location and database name are both variables?

Thank you for any assistance you can give me.

Jennifer

personaly the way i would do it is use and ini or text file that records the path the user installs on and then use the getprivateprofile string or read to return the infromation from eith the txtfile or ini file and ini file will be a bit more differcult with ini file But use a file to save the path is the eaiest way to do it then it can be as flexable as you like there are some good tuts on here on saving to a file

p.s using a txt file will be easyier