How to import one db into another? Complete with Forms, Queries & Tables ?

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I've got two Access data bases that I would like to merge into one so I can
create a control panel to access either.

Each has a number of reports, forms, queries and tables.

Can these be easily merged without risk of loosing any of the relationships
or anything?

If so how?

thanks for any help.
 
Will said:
I've got two Access data bases that I would like to merge into one so
I can create a control panel to access either.

Each has a number of reports, forms, queries and tables.

Can these be easily merged without risk of loosing any of the
relationships or anything?

If so how?

thanks for any help.
Click to expand...

It depends. What relationships currently exist? Will combining them
cause any duplicates in any unique fields or fields used in a relationship?
 
What I would do is keep the Tables only on both your existing databases.
Move the queries & forms to a 3rd database. Link the 3rd database to your 2
existing databases. The 3rd database will be your front end and your
existing 2 databases, the back end.

Hope it works for you!

Zafar
 
Back
Top