Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you run a query in Access 2007: "System Resource Exceeded" or "Query is too complex"

Error message when you run a query in Access 2007: "System Resource Exceeded" or "Query is too complex"

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

↑ Back to the top

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 "System Resource Exceeded" error message.

↑ Back to the top

Workaround

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

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

More Information

For more information about Access 2007, visit the following Microsoft Web site:
http://office.microsoft.com/en-us/access/FX100646911033.aspx

↑ Back to the top

Keywords: kberrmsg, kbexpertiseinter, kbtshoot, kbentirenet, kbperformance, kbprb, kbbug, kb

↑ Back to the top

Article Info
Article ID : 918814
Revision : 1
Created on : 1/7/2017
Published on : 10/15/2007
Exists online : False
Views : 171