Combining Databases

[Guest]

I have been given 2 databases which started out as one that was saved into
two place and were being updated by 2 different operators in the 2 different
locations. I need to combine them into one and try to decipher which updates
to keep and which to delete. Is there an easy way to combine them together
so that this can be done?

 

[John Vinson]

I have been given 2 databases which started out as one that was saved into
two place and were being updated by 2 different operators in the 2 different
locations. I need to combine them into one and try to decipher which updates
to keep and which to delete. Is there an easy way to combine them together
so that this can be done?

It's not hard to get the *tables* into the same .mdb file: use
File.... Get External Data... Import from the menu. If you import a
table which has the same name as an existing table, Access will attach
a number 1 to the name (so you'll have Customers and Customers1 for
example).

Synchronizing and combining the data can be a royal pain, however;
"not quite matches" are a *REAL* hassle. Good luck!

John W. Vinson[MVP]

 

[Guest]

I was hoping for any easy way out, but you confirmed my prior fears!! Thank
you!!
At least I can get it all into one location to prevent any further work -
thank you!