Query is too complex

Tech-Archive recommends: Fix windows errors by optimizing your registry

Dear all,

I have a query and returns error "query is too complex" if I run it in
Access 2000. But the query runs well in Access 97 environment. Please guide
me to solve this problem.
Thanks.

Regards,
Vensia


.

Relevant Pages

  • Re: Access Update Query Not Working From ADO
    ... The wildcards used with LIKE are different if you use ADO. ... "Barry-Jon" wrote in message ... > I have as saved access update query called 'qupdEnvironmentActivate'. ... > Environment Like "*", Environment Is Null); ...
    (microsoft.public.access.queries)
  • Re: Why does optimizer determine wrong cardinality when using MOD function? test included
    ... On thing I noticed is that the cardinality ... | I've setup a little test to help illustrate the problem. ... just to mimick my environment. ... | This estimate is very wrong because the query really returns 3750 ...
    (comp.databases.oracle.server)
  • Why does optimizer determine wrong cardinality when using MOD function? test included
    ... On thing I noticed is that the cardinality ... I've setup a little test to help illustrate the problem. ... just to mimick my environment. ... This estimate is very wrong because the query really returns 3750 ...
    (comp.databases.oracle.server)
  • up/pre-up usage
    ... Regarding my previous query on ethtool, due to the environment in use, ... Prev by Date: ...
    (comp.os.linux.misc)
  • Re: Strange behaviour across environments...
    ... > I view the query in query analyser. ... > Set RSSQL = con.Execute ... > environment they are not getting this error at all? ... > I've read that this can be caused by not selecting the ntext fields in a ...
    (microsoft.public.inetserver.asp.general)