Append query to another database

[livin''''life]

Thank you in advance for taking the time to read and answer(hopefully) my
question.

We have a networked split database that we use to track training of
soldiers. When a unit(containing multiple soldiers) leaves we would like to
give them an unsplit copy with just the records of their unit. I was
thinking of having a combo box to select the unit, then have an onclick event
to run all the necessary append queries and send the information to the
unsplit stand alone copy.

Everything works great except for one possible issue. The location of the
unsplit version is not always the same since we have many people at many
different locations that may do this for the unit.

Is it possible to have the append queries be prompted for the location of
the database as opposed to knowing the location?

 

[Jerry Whittle]

If the training records aren't confidential, why not just give the a copy of
the entire thing?

Also if can do some training while TDY, you might consider replication. That
way you could automatically update the master database with the latest data
when they get back. However replication tends to time out after a while and
might not work after a 179 day or longer TDY.