I have two Access tables (Table1 and Table2) of the same structure in two different offices.
Each month I need to "synchronize" the data so that they each have all the information. So I need all the records in Table1 that aren't in Table2 to be added to Table2 and all the records from Table2 that aren't in Table1 to be added to Table1.
How wouls I do this? What techniques would I use?