querying multiple databases

[sedgely]

We have an application at work that populates an access database, the problem i've got is that a new database is created each calendar month. Each database contains one table (the structure of these tables is identical).
My question is - Is it possible to build a query that looks at several of these "monthly" databases depending on a date range selected from a form?

Craig

 

[THoey]

First thing I would do is shoot the developer of the first application. A new DB for each month is unecessary, unless you are talking about so much data that it has to be that way. This is going to make this difficult at best. We would need to know more about these DB's and their naming convention. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[sedgely]

Thanx Terry
Somehow i knew this was going to be a difficult one! and i would agree very strongly with your first comment. As for the amount of data - each month there are about 15000 records in 170(ish) fields!
The db's are generated automatically at the beginning of each month and populated daily throughout the month then dumped onto the server each db being named: ae042002, ae042002 etc. where 04 is the month and 2002 the year.

Good system eh