I am trying to periodically merge two tables from 2 identical ms access databases as well as one sub table to that table. This is required on a periodical basis as the hardware in place will not support a live link.

The Source database will be the dominant database where all the programming for updating the tables will originate. I'm then thinking: import table to source db, append and update the destination table to source table,...