I have several Access 2007 databases with fairly complex queries that work without problem in 2007. But when I try to open the same database/query in Access 2010 I get "Query to complex" error message and the query will not open. I can probably resolve this by doing a lot of work splitting the "offending" queries up or redesigning hundreds of queries ... but give me a break... Is there an easy fix??? Is this do a change in some default memory or other registry setting in Access 2010 setup? Help.