Would each query in the query be a separate and distinct ODBC session?

I'm going to try the Make Table and see if that cures the problem,

"Gary Rowe" wrote in message
...
Could it be that your query of queries is the problem? There may be a
limit
on the number of ODBC sessions that could be happening at once. Perhaps
you
should use a make table query for your last query and then use ODBC to
connect to the table instead.

"Dkline" wrote:

I have an ODBC connection between an Access database and an Excel
spreadsheet. If I open the Access mdb and run the query, everything is
just
fine.

The query (although a qurey of queries) is not that complicated or large.
It
returns only 240 records.

When I open the Excel file and it goes to the same query as its
datasource,
I get this error:
"[Microsoft][ODBC Microsoft Access Driver] Could not start session. Too
many
sessions already active."

Why does it work in its native Access but the same query causes Excel
have a
conniption?