Merge 2 identical databases together

We have 2 people in separate locations making entries for
convention registrations. They are both using an
identical Access db. I anticipate that we are going to
have duplicate PK's that will need to be reassigned but
these will still need to retain their links to
subordinate tables and lookup tables.

Presume tblA is the master, and I want to bring all the
records from tblB into tblA. How do I change the
duplicate PK's in tblB so that it repopulates starting
with the next available PK from tblA. With Cascades on,
this will also save the link to sub tables when the PK
number has changed?

Can someone step me through this process so that I can
merge these two db's into one set of records.

TIA,
Sandra

Sandra

One approach would be to investigate the "replication" features of Access
and set this up.

Another approach would be to add a field to your table(s) that will hold
Location. This way you could keep a master table that would have its own
Autonumber ID, a (LongInt) foreign key to the locations' AutonumberID, and a
Location. You can use your "master" ID to link to child records related to
the master database, and you can use the Location ID to link to child
records set at the locations.

You would have to repeat this design for each "child"-level record you
wanted to duplicate in your master table.

Good luck

Jeff Boyce
Access MVP

"sandra grawunder" wrote in message
...
We have 2 people in separate locations making entries for
convention registrations. They are both using an
identical Access db. I anticipate that we are going to
have duplicate PK's that will need to be reassigned but
these will still need to retain their links to
subordinate tables and lookup tables.

Presume tblA is the master, and I want to bring all the
records from tblB into tblA. How do I change the
duplicate PK's in tblB so that it repopulates starting
with the next available PK from tblA. With Cascades on,
this will also save the link to sub tables when the PK
number has changed?

Can someone step me through this process so that I can
merge these two db's into one set of records.

TIA,
Sandra

Thanks Jeff for the info!
-----Original Message-----
Sandra

One approach would be to investigate the "replication"
features of Access
and set this up.

Another approach would be to add a field to your table
(s) that will hold
Location. This way you could keep a master table that
would have its own
Autonumber ID, a (LongInt) foreign key to the locations'
AutonumberID, and a
Location. You can use your "master" ID to link to child
records related to
the master database, and you can use the Location ID to
link to child
records set at the locations.

You would have to repeat this design for each "child"-
level record you
wanted to duplicate in your master table.

Good luck

Jeff Boyce
Access MVP

"sandra grawunder" wrote in
message
...
We have 2 people in separate locations making entries
for
convention registrations. They are both using an
identical Access db. I anticipate that we are going to
have duplicate PK's that will need to be reassigned but
these will still need to retain their links to
subordinate tables and lookup tables.

Presume tblA is the master, and I want to bring all the
records from tblB into tblA. How do I change the
duplicate PK's in tblB so that it repopulates starting
with the next available PK from tblA. With Cascades
on,
this will also save the link to sub tables when the PK
number has changed?

Can someone step me through this process so that I can
merge these two db's into one set of records.

TIA,
Sandra

.