Replication of table data between 2 Access DBs

[Guest_imported]

Hi,
I would like to replicate a Access database to another Access database. How to do that??!!

Let me explain the scenario.. I've a database test1 with table t1 and another database test2 with table t2. t1 & t2 have exactly the same structure. Assume t1 is getting updated & I would like to update the data in t2 with that of t1. That is, I want to copy the whole stuff in t1 to t2.

I can't delete all rows from t2 & just insert t1 into t2 as there are some unique rows specific to t2 also.

How to do this??!! U help is much appreciated..

Thx in advance..

regards,
Krishna

 

[JimHorton]

Krishna,
Access supports Replication. I've never used it, and hope I never do, it just seems like an administrative nightmare. You can look in Help under Replication, and I think there is also a 'Replication Wizard'.
--Jim