Too Many Client Tasks

[Guest]

I built an Excel spreadsheet that has 204 updating queries into an Access
database. I have the queries set to update when I open the spreadsheet, but
I get an error message that says "Microsoft Excel [Microsoft][ODBC Microsoft
Access Driver] Too many client tasks"

I used the function: Data; Import External Data; New Database Query. I
pointed it to the Access database and the data. My first number of tries
worked, when I tested them, then after I built the whole worksheet it failed.

Any idea how what is going wrong or what I can do to get this spreadsheet to
work?

 

[Guest]

hi,
if you are using the refresh all command, that is your
problem.
You may have to write an xl macro that will refresh each
MSQ one at a time. Yeah, i know. sucks. but that is what i
had to do to refresh just 6 MSQs. OR you can go into
microsoft's site and see if they have a better driver.
the problem is not access or excel. it is the driver.

 

[John Nurick]

At a guess - and it's only a guess - the message means what it says:
trying to run 204 queries at the same time is more than the ODBC driver
can handle.

If you were running them from VBA I'd suggest including some DoEvents
statements or other delaying measures in the code. But I've no idea how
Excel handles things; it's probably worth asking in an Excel or ODBC
forum (there are one or two Access ODBC newsgroups).

I built an Excel spreadsheet that has 204 updating queries into an Access
database. I have the queries set to update when I open the spreadsheet, but
I get an error message that says "Microsoft Excel [Microsoft][ODBC Microsoft
Access Driver] Too many client tasks"

I used the function: Data; Import External Data; New Database Query. I
pointed it to the Access database and the data. My first number of tries
worked, when I tested them, then after I built the whole worksheet it failed.

Any idea how what is going wrong or what I can do to get this spreadsheet to
work?