How to combine multiple Access databases

[Kelly Hawthorne]

I have 3 Access Databases that I need to combine into one (The primary
database is one of the 3) and if possible have any information added to the
subordinate databases automatically be entered into the primary database.
Does anyone know how to do this?

 

[Rick B]

I would probably import the data tables from the "bad" databases and then
create update queries to copy the records to the desired tables in the
"good" database.

Once I had everything there and working, I'd delete the "bad" databases.

Rick B

 

[John Vinson]

I have 3 Access Databases that I need to combine into one (The primary
database is one of the 3) and if possible have any information added to the
subordinate databases automatically be entered into the primary database.
Does anyone know how to do this?

This can be easy (using File... Get External Data... Link and running
a series of append queries) or almost nightmarishly difficult (if you
have duplicate autonumber values, almost-duplicate data which must be
manually investigated to see if it's actually a duplicate or just a
similar new record, etc.)

Storing the "same" data in two or three databases is *emphatically*
bad design if there is ANY way to avoid it. Why three databases? Are
these on the same LAN, or at remote locations? Is there any
possibility of using a split database where the tables are in a .mdb
file on a shared drive, with the three users all linking to it?

John W. Vinson[MVP]

 

[Kelly Hawthorne]

I found that I was able to cut and paste from within Access.
Thank you for the ideas. I printed them and will hang on to them for future
use.
Kelly