Too many client tasks

  • Thread starter Thread starter Guest
  • Start date Start date
G

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"

Any idea how I can get this spreadsheet to work?
 
SCW said:
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"
Click to expand...

I'm not sure how this is handled by MS Query but I suppose it could be
trying to open more concurrent connections than Jet (MS Access) can
reliably support. To ensure you aren't hitting the hard coded 255
connection limit, ensure the lock file (file with same name as the mdb
but with a ldb extension) is cleared.

Jamie.

--
 
Back
Top