Probable Access 2007 SP2 Error: Query too Complex

  • Thread starter José António Silva
  • Start date
J

José António Silva

Having upgraded some of my clients to Access run-time SP2 I suddenly run into
the following problem: Error 3360 Query too complex.

The remaining clients still using SP1 are fine like they have been in the
last few years with Access 2003. The query hasn’t changed. So, this should be
an Access 2007 SP2 flaw.

I’m currently using compiled accdr files ODBC linked with SQL Server. And,
yes, my query is complex. It has a UNION ALL and many fields. But it has been
running fine till now.

So, my question is.
Could anybody tell me what kind of possible query restrictions have been set
in Access 2007 SP2?
Thanks
 

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

Similar Threads

Query is too complex after install Access 2007 SP 2 !? 25
Query is too complex 5
"Query Too Complex" Access 2000 help me make this one query less complex? 0
Query Too Complex 8
Another query too complex problem 3
Select query too complex? 8
query too complex 2
query too complex 3

Top