Merging 3+ Databases into 1

[stuartk]

Hi All

At our church we have 3 databases as follows:

Guests
Youth
Kids

Each database has a Frontend (stored in users My Docs folder) and a Backend (stored on a shared folder on our server)

Would it be possible to merge these databases into one for query / mailshot purposes but still keep the databases separate?

Like a create a master database based on the info contained in all 3?

Info greatly appreciated.

Regards

 

[Dairy Farmer]

I take it that you still want to have the 3 seperate FE's and that occasionally you need to run the query.

Three options:

Just create a new FE and link the 3 BE's tables to it.
Create your query in this FE.

In each FE link all tables from 3 BE's.
In each FE create the query.
Now you can run the query from which ever FE you are in.

Combine all 3 FEs into one.
Link all 3 BE tables into FE.
Create query.
Make a switchboard that allows the user to select which "section" (Guests, Youth, Kids) of the DB they want to work on.