Thread: ODBC Error
View Single Post
  #1   Report Post  
Dkline
 
Posts: n/a
Default ODBC Error

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?