Combining 10 databases into 1

  • Thread starter Thread starter grumy
  • Start date Start date
G

grumy

I have 10 identical relational databases with different
data in them which run on individual machines. I now want
to have one on a network and transfer the data from the 10
into one. Is this possible ?
 
Hi,

Yes. I would review the information on this website regarding "split
database design":

http://www.granite.ab.ca/access/splitapp/overview.htm

In concept, what you would want to do is to have multiple identical front
ends for the 10 users and one back end containing data (i.e. tables) only.
A front end .mdb file contains only user interface objects i.e. forms,
queries, reports, modules etc. A back end .mdb file contains tables only. In
your case, the backend has to be built by combining/merging the tables from
each of the 10 databases using append queries.

I realize this is a generalized answer, you would have to work through the
detail steps and post back if you need help with specific tasks.

HTH,
Immanuel Sibero
 
Back
Top