Solved: Update identical tables

[Yvaine]

i have two identical database with same structures, but not necessary the content of records. While i update value of one table in one of the database (including change, insert, delete), how can i reflect the same changes to the same table in another database.

[CreganTur]

While i update value of one table in one of the database (including change, insert, delete), how can i reflect the same changes to the same table in another database.

Is there any reason why you couldn't append all of the records from Database B to Database A? Then you could just Link the table(s) from Database A to Database B- then the changes would be reflected in both databases always, because they're both working from the same table.

If this is not an option, and if you're making these changes via Forms, then you could update the external database's tables via an ADO connection.