Merging two Access 2007 databases

[colinrharris]

First let me say that I'm a networking guy, not an Access, or any other sort of programer.

That said, I have two Access 2007 databases that are identical except that each was populated with different data. It is now necessary to join the two databases together to make just one database that includes all the data from each. I have read a little about append queries and think I could follow step by step instructions to do that. However, the database consists of multiple related tables and I dont want to lose the relationship between these. For example, there is, amongst others, a client table and a contact table and a site table.

How can I merge these databases together without losing any functionality?

Thanks

 

[Remou]

It will not be so easy. You will need to add the support tables first, then bring these back to the database to be added and update the relevant fields to the new codes by relating to the original support table and the new support table. You will need to work slowly, with a lot of backups.

[tt]Database 1
Widgets: Main Table
Id Descr Colour
1 Gizmo 2
2 Dongle 3

Colours: Support Table
Id Colour
1 Red
2 Blue
3 Green

Database 2
Widgets: Main Table
Id Descr Colour
1 Gizmo 3 -> May need to be deleted as a duplicate
2 Thingy 1

Colours: Support Table
Id Colour
1 Orange ->Appended as 4
2 Red ->Not appended, Code change
3 Blue ->Ditto[/tt]

And so on.