I need to merge 2 simillar access databases from 2 computers to form a single
database. How do I do it?
This might be pretty easy - use File... Get External Data... Link to
link the tables from the second database and run Append queries.
It might be almost nightmarishly difficult, too. What's in the tables?
Do you have Autonumber ID's (which will almost certainly be duplicated
in the two databases)? Do you have foreign key links from autonumbers
to related tables (which will require updating before you append the
data)? Do you have duplicate data between the databases? or, worse,
almost-duplicate data such as two people with the same name but a
different address, who might actually be one person who moved?
The details will differ but this project can end up being a LOT of
work. Please post with an explanation of the nature of the data.
John W. Vinson[MVP]