merging 2 access database

[bimosekin]

How can I merge the contents of two access database, while
at the same time resolving any primary-key conflicts. I
want only the contents of old-database to be merged with
the new-database, without transferring the tables.

Thanks,
bimosekin

 

[John Vinson]

How can I merge the contents of two access database, while
at the same time resolving any primary-key conflicts. I
want only the contents of old-database to be merged with
the new-database, without transferring the tables.

You can use File... Get External Data... Link to link to the database
from which you wish to merge, and then run Append and Update queries.
It'll be tedious and require careful thought - Access has no way of
knowing how to resolve primary-key conflicts; you'll need to provide
that logic yourself in some manner.