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"

Any idea how I can get this spreadsheet to work?

 

[onedaywhen]

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'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.

--