If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do you merge two Access databases into one set of tables | Charles, UVA Health System | General Discussion | 0 | December 2nd, 2004 09:25 PM |
Mail merge conversion from Word to .NET code. | mutton | Mailmerge | 1 | November 17th, 2004 02:09 AM |
How to merge databases | General Discussion | 1 | June 24th, 2004 05:04 PM | |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |