"Can't open any more databases"

[MJSmit]

I get the error message "Can't open any more databases" when I run the following query:

SELECT qIndProgJUN03.Code, Sum(qIndProgJUN03.MaxOfIndValue) AS JUN03, Sum(qIndProgDEC03.MaxOfIndValue) AS DEC03
FROM qIndProgJUN03 INNER JOIN qIndProgDEC03 ON qIndProgJUN03.Code = qIndProgDEC03.Code
GROUP BY qIndProgJUN03.Code;

I actually created it from the Design view, so I think there is nothing amiss with the instructions as such. I already found somewhere in the posts that Access can only open 32 tables at the same time. qIndProgJUN03 and qIndProgDEC03 are simple selection queries, both from the same union query, which is based on one table (stored in a different database).

Finally, the error message is in my Windows language (not English), whereas my Office is in English. Any hints?

 

[BNPMike]

Are qIndProgxxx03 tables or views/queries? From the namimg they look like queries - if so how many tables are involved in them. Remember Access/Jet will run the queries at run-time, adding the SQL to the SQL specified in your final query and treating it as one big query.

 

[MJSmit]

Actually, you are right. I've recreated them as Tables, and it works immediately. They were selection queries, based on a union query, based on a set of six selection queries, each involving five tables... I easily passed the 32 mark. Leaves me wondering why the error message was in Dutch instead of standard Office English...