Help and Support
 

powered byLive Search

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

View products that this article applies to.
Article ID:918814
Last Review:October 15, 2007
Revision:1.6

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 (http://office.microsoft.com/en-us/access/FX100646911033.aspx)

Back to the top

APPLIES TO
•Microsoft Office Access 2007

Back to the top

Keywords: 
kberrmsg kbtshoot kbbug kbperformance kbprb kbexpertiseinter KB918814

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by E-mail, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.