MS Excel Error: Too many client tasks

B

Bodo

Hi,
my Excel sheets are populated by 50+ queries from an Access database.
When I click refresh all external data in Excel, it starts refreshing but
after a minute it stops with this error message:

[Mircosoft][ODBC Microsoft Access Driver] Too many client tasks

I don't get this message when I refresh external data one by one by clicking
on refesh data.

I use Excel 2002 SP3 to link data from an MS Access database
via ODBC DSN configured with {Microsoft Access-Driver (*.mdb)}


Appreciate any thoughts on how to troubleshoot.
 
J

Jan Karel Pieterse

Hi Bodo,
my Excel sheets are populated by 50+ queries from an Access database.
When I click refresh all external data in Excel, it starts refreshing but
after a minute it stops with this error message:

Set the query properties so they do not refresh in the background.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
B

Bodo

Thanks Jan for your respond,
I unchecked the refresh property and that works fine.
Thanks
Bodo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top