ok, so heres the situation..

several databases, all hitting a couple million records in a single table so need to archive..nearing 2gb limit (is this a fixed limit or can i go over?)

created archive databases, one per month, which split it to about 350Mb per database (single table)

what i need to do is still allow the reporting of the historical data in teh monthly archives so whats the best way to do this?

i had though create a reporting front end, ask user for start date and end date, link the relevant archives relating to these dates to allow the reporting and create custom recordsets?

still a bit stuck as to how to create a single recordset from teh multiple archive databases without killing performance? the start database was pretty slow. network based 10Mbit LAN.

looking for suggestions as to an implementation type to facilitate the above. will code the solution myself although examples of how you guys do things are always welcome

TIA

B