Linking different database

  • Thread starter Thread starter Beginner
  • Start date Start date
B

Beginner

I have 3 different tables of data. But all the 3 tables
use the same set of 4 lookup tables.
The underlying process for all the 3 tables are the same.
(But the tables cannot be integrated into one single
table ).
Right now I am employing 3 different databases for these 3
tables and uploading the 4 lookup tables into each of
these 3 databases. Can I have a separate database for just
these lookup tables and/or the 3 tables ? Is it possible
to link the 3 different databases to this one database?


The reason for 3 different databases is due to the
numerous queries in each database. Is there a way to
consolidate the queries into one piece of code so I can
integrate all the process into one database and all the
tables in one database?

Any help is highly appreciated.

Thanks in advance
Beginner
 
I'm not exactly clear from your description, but an idea occurs to me. A
pretty standard design for a database application is to separate the data
from all the other components (e.g., queries, forms, reports, etc.).

It might be possible to put all the queries (and other non-table components)
in one .mdb file, and consolidate all the data into another .mdb file. If
the "3 different tables of data" are, in fact, all identical structures, you
could combine those into one table. If you need to identify 3 unique
sources, add one more field to the table that shows Source.

All of this is putting the cart before the horse, though. You've described
"how", but not "what" ... as in "what are you trying to accomplish?", and
"what data/arena/domain are you working in?"

More info, please...

Jeff Boyce
<Access MVP>
 
Back
Top