Query is too complex after install Access 2007 SP 2 !?

[jdkraft]

In the meantime I found out that if I first make a table (with make table
query) from the union query and then in my last query I join this new table
instead of union query then I don't have any such error anymore.

The problem is therefore in union query! Why?

Ivan

I agree with this assessment and have been able to reproduce it with a
UNION query I have as well only under SP2.
Have you gotten anywhere with it?

Joel

 

[stephanie_megan]

I was having the same problem and removing the "All" Fixed it - THANK YOU THANK YOU THANK YOU THANK YOU!!!!!!!!!!!!!!

 

[Milhouse Van Houten]

Has anyone? It seems a little hard to believe that this hasn't even made it
into the KB.

 

[Kara]

The problem is with SP2. I'm able to open the same database in Access 2003
and all of the UNION queries work fine. I originally created the Access
database in 2007 (saved it as an MDB file) and it worked fine, until the
update. Now, in Access 2007 I get the "Query too complex" message unless I
use a make-table query first from the union query. This is an annoying
work-around that I don't have time to do for the entire database. For now my
only option is to go back to using Access 2003. Too bad...I really liked some
of the new features in 2007.

Has anyone heard when or if there will be a fix?

Thanks,

Kara

 

[Jim]

Tried the June 2009 hotfix collection for Office 2007 SP2 but no fix in there
yet. Has a work around or hotfix come out for this? Also still no knowledge
base article as far as I can see.

Jim

 

[gsva1983]

Hello,
I know this is a really old thread, but would like to know if anyone has any working solution to the "query too complex" problem? We have also had the same issues with Access 2010. Any information would be helpful.

Thanks,
Vijay