Too many client tasks


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?
 
Ad

Advertisements

O

onedaywhen

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"

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.

--
 

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