Destination DB As Variable?

We have a blank database that other units are copying to use at their bases. Most of the other users aren't Access savvy and I've been trying to develop ways to overcome this learning curve by automating as many "customizing" functions as possible. For instance, each unit that uses the database has different organizations, aircraft tail numbers, personnel listings, etc. I've got pretty much everything covered except one item.

The database is set up in a way in which it copies itself when it closes providing the UserID level is not 'Read Only.' This database doesn't use front/back end to control its users. It uses a log-on level based on a security example from this board.

It also has an archive function in which several tables are appended to an 'archive' database. This is a basic copy (minus of few functions) of the main database. The intent is to reduce the number of records in the working db w/o losing historical value.

I think the copy function shouldn't be too much of a problem for new users. I've developed a help file that should walk people through the steps to change the location of the copied file. This is done w/ a *.bat file and the change should be as simple as changing text. However, the archive function works off of severl append queries.

Is there a way to change the destination db other than in the query design view? Maybe a code or a box that treats the file location as a variable? The destination db is U:QA2k6 DatabaseArchiveQA Archive.mdb That works fine for us, but a new unit will have a different file location.

I'll try to make a smaller/scaled-down copy of the db later to post if anyone wants to check it out.