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.
On Sun, 23 Jul 2006 17:53:02 -0700, noodleBrain
<noodleBrain[ at ]discussions.microsoft.com> wrote:
[Quoted Text] >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 [Microsoft Access MVP]
Please respond in the newgroup and not by email.
|