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, then the 'sub table' as well. Same again for the Destination table.
In order to achieve this I need to sort the primary key but at this point Access will only accept the autonumber as the primary key. I've been trying to use the site number and the issue number as the primary key but to no avail.
Is there an easier way of doing this as linking isn't an option.
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, then the 'sub table' as well. Same again for the Destination table.
In order to achieve this I need to sort the primary key but at this point Access will only accept the autonumber as the primary key. I've been trying to use the site number and the issue number as the primary key but to no avail.
Is there an easier way of doing this as linking isn't an option.