Data management issues

[Razor]

Hi,

I have written a database that consists of four feeds that
get replaced monthly and a dozen queries and reports. The
feeds go in a backend MDB and the queries/reports go in a
frontend MDB. I have one such MDB-pair per business.

My problem is that I am soon going to have to create
reports for 30 such businesses. I don't want to end up
with 30 MDB-pairs.

What is the way to implement this that will require the
least maintenance? Could you point me to any literature
that suggests solutions to this kind of problem?

Here are some characteristics about the feeds:

1. Employee feed: Replaced monthly, used by all
busineses, half million records
2. Billing feed: Replaced monthly, tied to business'
list of Expense Codes
3. Login-data feed: Available for only some businesses,
right joined, version with and without this feed.
4. Expense Code feed: One per business, changes
occasionally
5. Billing feed aggregated: Year-to-date aggregate of
billing feeds

Thanks for your help!

Razor

 

[Albert D. Kallal]

Why not just have one front end, and 30 back ends?

You could also consider putting all data into ONE mdb file. That would be
about 15 million records for the large table. However, before you consider
that option, why do you need 30 front ends?

So, it is not really clear why you have a different front end for each back
end of data?

It would seem to me that one front end that connects to a back end of choice
would do the trick here.

Feel free to expand on the above...as without more info...one front end
seems to be the solution here...