Microsoft KB Archive/918814

= Error message when you run a query in Access 2007: &quot;System Resource Exceeded&quot; or &quot;Query is too complex&quot; =

Article ID: 918814

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Access 2007

-





SYMPTOMS
In Microsoft Office Access 2007, you may receive the following error message when you run a query with a join to a subquery and a long WHERE clause:

System Resource Exceeded

You may also receive the following error message when you run the query:

Query is too complex



CAUSE
This problem occurs because Access 2007 has a 16-join limit. Additionally, large and complex query criteria in the WHERE clause can cause the &quot;System Resource Exceeded&quot; error message.



WORKAROUND
To work around this problem, change your query so that there are no more than 16 joins.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
For more information about Access 2007, visit the following Microsoft Web site:

http://office.microsoft.com/en-us/access/FX100646911033.aspx

Additional query words: AC2007 ACC2007 Access2007

Keywords: kberrmsg kbtshoot kbbug kbperformance kbprb kbexpertiseinter KB918814

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.