Is there any way to keep two tables (one located in an mdb on a network drive and the other located in an mdb on a local computer hard drive) synchronised automatically? The source table sitting on the network is pretty large (over 40,000 records) and is updated every 10 seconds or so by multiple users. I've tried using an append query running on a timer loop to update the local table but this sucks a lot of memory due to the large volume of records in the source table.



Can anyone help?