Query too complex - Possible solution

Look for suspicious query or field names in the query itself, or in any other queries leading up to it. Avoid anything in the Microsoft Access special characters list. At the time of this writing, round parentheses ( ) are not in the list, but they should be. I had a flakey "Query Too Complex" error, failing sometimes but not others. The error went away when I deleted a pair of parentheses from the name of a query a couple of queries earlier in the chain.