Problem with Access DB when moving VB .Net Project

[TStirman]

Ok, here is the quick rundown:

I've created a VB program in VS .Net 2003 (and also VS 2005), with .NET framework 2.0, that works with a database created in Access 2007. This program was created on the Development workstation at my house, but I need to install the program into the network at work. I know that if I move the program's project folder, I can simply reconfigure the DataAdapter to point to the new path where the database is, but I won't be able to do that all the time (as the program must be implemented into 3 other branches in 3 different states.

So, my question is this:

Is there any way to create a installation file that will place the database in a pre-specified folder that will be created during installation and integrate the path into the data adapter and have it work no matter where it is installed? Even if the drive letter is different?

The requirement is that the IT guys should simply run the setup file and the rest is done for them. Is there any way to do this?

There are no errors in the code and the program works as it should on my machine, so basically what I need is advise on creating the setup file to work on any machine, the network implementation is not something I will have to do.

[kenobewan]

Are you using Visual Studio? You can create a setup project that results in an exe. Haven't checked it out, but as VS 2005 has better integration with SQL you may be able to do something with that but I'd be surprised if you could do everything you want like this.

[TStirman]

Are you using Visual Studio? You can create a setup project that results in an exe. Haven't checked it out, but as VS 2005 has better integration with SQL you may be able to do something with that but I'd be surprised if you could do everything you want like this.

Yes, I am using Visual Studio .Net 2003, but I haven't actually played around with the setup project very much, because I have never done it. The problem I know that I will have, even with an installation is the Data Adapter configuration and the path pointing to the Access database. The program runs on one machine, but I do not know if there is a way to configure the data adapter during the installation process, so that it points to the new location of the Access database. :(

I'm pretty lost when it gets more complex than what I have done, thus far, with my program. I have only about 9 months worth of experience when it comes to programming with visual studio, so I haven't expolored all that can be done with it and how.