Re: Merging Data Dynamically

On Wed, 5 Dec 2007 22:39:21 -0000, "Phil Stanton"
<phil@xxxxxxxxxxxxxxxxxxx> wrote:

The way I look at it is this: if the data is REALLY separate, I would
not mind multiple back-ends. That seems to be the case in your
situation. But if you had told me your Sailing Clubs are all owned by
one company, which would sometimes want to run reports across the
whole enterprise, or send out a mailing that should not have dups (and
people can be member of several clubs), or lower all prices by 5%, you
can see where multiple back-ends would quickly become unmanageable
whereas an integrated one would be soo nice.
Also, the OP hinted at writing a union query to get the records for
Removals1, Removals2, Removals3 and Removals4, and then later come
back and add a new Removals5 to the query. That's where I say "really
bad idea".

-Tom.


Hate to disagree with an expert, but I run 4 or 5 back end DBs with the same
front end. Largely different sailing Clubs, so members, boats and moorings
and parking spaces used, but also use the same front end for friends, and
Rotary Club. Each DB has it's own menu so that irrelevent forms and reports
don't appear. All DBs have identical sets of tables and relationships, but
of course say the Rotary Club tables have no records in the boat and spaces
table. I have a form which you use to select which set of data you want,
then loop through all the tables to detach them from 1 back end database
then loop through all the tables to attach them for the new front end
database.
Works a treat.

Phil

"Tom van Stiphout" <no.spam.tom7744@xxxxxxx> wrote in message
news:smddl31k8to7v9eqeh5rhlb5ncrfbo4ds1@xxxxxxxxxx
On Wed, 5 Dec 2007 06:14:49 -0800 (PST), karenjfrancis@xxxxxxxxxxx
wrote:

This is a really bad idea. Rather you consolidate into one database,
that can handle multiple Projects.

-Tom.


I have 4 Access databases, all with the same data model but different
data. I want to build a front end that brings all of the data in the
4 databases together into one.

Assuming my table of interest is called Removals, if I create linked
tables I end up with Removals1, Removals2, Removals3 and Removals4. I
could easily write a query to base a form or report upon to
concatenate all of these tables' data into one view. However, the
users take an empty database to use as a template for when a new
project is released so the view needs to be able to compensate for the
sudden addition of Removals5 and create a linked table for it.

Is this possible?

Regards

Karen

.

Relevant Pages

  • Re: Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ... You might consider checking licensing costs at the oracle store ...
    (comp.databases.oracle.server)
  • Re: Conversion to 2007
    ... All I know Iis have multiple tables used to store data and multiple tables ... Sometime I used multiple queries to filter the information or shape reports ... Office Pro 2007 and hope it will work as well with office 2003 ... so a well-designed database may work without modification in A2007. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: MySQL vrs SQLite
    ... Can multiple applications or multiple instances of the same ... But only one process can be making changes to the database at ... >>will need to implement your own data conversion though. ... declared as integer and float to the appropiate Python types. ...
    (comp.lang.python)
  • Re: Rails app organization question
    ... I -really- like Rails, though. ... Have one instance of the app and somehow allow it to use different databases depending on the user's login. ... Have multiple instances of the app running on virtual servers, similar to how cPanel sets up accounts for multiple hosts -- each host has its own directory, MySQL database, and so on. ...
    (comp.lang.ruby)
  • Re: How do I print only new records in Access?
    ... (months, counties, clubs, ... ... multiple tables, and you will have to modify how you refer to those tables ... > How do I print client records based on date of entry utilizing template ...
    (microsoft.public.access.tablesdbdesign)