Re: Too Many Client Tasks

From: John Nurick (j.mapSoN.nurick_at_dial.pipex.com)
Date: 01/10/05

  • Next message: John Nurick: "Re: Linking Certain Access fields into specific Excel Column" 
    Date: Mon, 10 Jan 2005 21:11:51 +0000

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

    On Mon, 10 Jan 2005 03:31:11 -0800, SCW <SCW@discussions.microsoft.com>
    wrote:

    >I built an Excel spread*** that has 204 updating queries into an Access
    >database. I have the queries set to update when I open the spread***, 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 work*** it failed.
    >
    >Any idea how what is going wrong or what I can do to get this spread*** to
    >work?
    > 

    --
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
  • Next message: John Nurick: "Re: Linking Certain Access fields into specific Excel Column"