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

 

[jabrony76]

Krishna,
How "live" do you need this data? If it's not imperative that the minute you enter the data into T1 it be in T2, you can run an append and delete query to add data from t1 into t2 and then delete data from t1.

If you need the data "live", you could either add a control to the data entry form that would do this or place this on the "OnExit" property of the form. Not sure if i've answered the exact question but hope it helps.

Andy
s-)