updating data

[Guest]

I have a split mdb on a LAN (LAN 1) at one location and a different split
mdb on a LAN (LAN 2) at another location. Many miles between them. With a
VPN connecting them.

My application on LAN 1 needs updated data, say daily, from 3 tables from
the database on LAN 2. To date I have just been copying and pasting the
three tables into the BE mdb file on LAN 1 from LAN 2 BE mdb file. I could
link LAN 1 application directly to LAN 2 mdb file tables to get 'live' up to
date data but it is to slow accross the network.

What is the best way to automate my process of updating, once a day, the BE
tables (3 of them) on LAN 1 from the BE tables on LAN 2.

Cheers,

nB

 

[John Nurick]

One way is to write code that creates a new MDB file (let's call it
Transfer.mdb), runs action queries that export the three tables (or just
the updated data) to it, and finally transfers it to the other LAN (by
email, ftp or just copying it across the VPN).

At the other end, write a procedure (called from a form's OnTime event
so it runs however often you want) that opens Transfer.mdb, runs action
queries to update the three tables with the new data, and finally
deletes Transfer.mdb ready for next time.