Is there a bug in Access 2007 SP2 ?

A

Alfred

Can anyone tell me why a group of queries runs perfectly fine when using
Access 2007 SP1.

However, after upgrading to SP2, with no other changes taking place, the
identical queries now return the following error "Query too complex" ?

Thanks !
 
J

Jerry Whittle

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.
 

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

Probable Access 2007 SP2 Error: Query too Complex 0
Differenct between Access XP SP1 and SP2 4
Bug in rendering a .docx file in Office 2007 Enterprise edition 1
Query is too complex after install Access 2007 SP 2 !? 19
Bug in Excel 2007 SP2 charting 0
long-time report fails intermittently under Access 2007 SP2 6
Access 2007 - Query Design View Error - " is not a valid name... 13
Analyze with Excel In Access 2007 Sp2, Office 2007 0

Top