1) Assuming you have coded linking/relinking tables, you could (in theory) relink to all the dbs (including new ones) as they are created, then run union queries to put all the totals for each month into one table then use aquery to reformat/sum these together.

2) Or you could pull off the statistics you need as the db is archived (thus not changed?) then just link to those stats tables (which would cut your running time down) and only have the currently live month with pulling info?

3) Upgrade to a bigger db

4) uh, find some other way to get the data you need.

(2) sounds like a good one, as all archived data (in theory) doesn't change, ,so if you pull off some combined stats tables and read those, you won't need to do the recalcs each time. Just unions and adding together


Post up what you decide to do and whether it works pls (I'm curious!)