Combining several databases into one

J

Judy

(I am new to the job) We have approx. 7-10 databases that need to be in one
location for more efficiency. I need advice on this. First i think that i
would create a new group then link tables from the original location and then
import the other reports, etc. Is this an accpetable way to do this or
should i copy all the tables, records, queries into one main db? I started
to do that and quickly relized that it would be huge. Help!
Judy
 
M

mscertified

Do these 7-10 databases share any information?
Are the databases split?
I'm not sure why you want to combine them or what benefits you will get.

You could create a new database (I dont know what you mean by 'group') and
import all the objects from all the databases. If the databses are split, you
will need a new back end to import all the back-end tables and a new
front-end to import all the front-end objects. Then you will need to link the
two together.

Since each database can have a separate start-up form you'll need to sort
that out.

-Dorian
 
Top