Dumping data from one database to another

Hi All,

We have two offices, each with their own Windows 2000 server, which are connected with a VPN tunnel but it is extremely slow to try to have an Access 2000 database sit on a server in one office and be used by the other office.

Since we are not yet up to web accesible databases, I wanted to have the original database sit in the field office and a copy of the database in the central office. Both have staff enter data. Then, every two weeks, I would like to dump the "new" data from central office to the field office (after two weeks data cannot be edited by staff). I have no trouble doing an append query across the VPN tunnel to accomplish this for one table, however, if data has been entered into a sub table, therefore creating a foreign key relationship, how do I recreate that in a data dump?

Any ideas? Thank you, Betsy

You could load all the new data into a recordset, then write the recordset to the DB. The recordset will create new keys based on the DB it's writing to.

Thank you! I had never used a recordset and it seems, after reading up on it, that it is exactly what I need to be using. I will probably pester you again if I run into problems while attempting to use one.

Good to know someone from Wild, Wonderful West Virginia is helping me - that is where I was born, although now am called a Hoosier.

BetsyBean

West Virginias are the stuff. Just that noone stays and gives credit. Soon as I get out of WVU, I'll be doing the same :-p

Recordsets are ez, shouldn't have much trouble.