"System Resource Exceeded" error message when you perform a query in Access 2010

Applies to: Access 2010


Assume that you apply the hotfix package that is described in Knowledge Base (KB) article 2553447 to Access 2010. However, when you perform a complex query that applies to many records, you receive the following error message:
System Resource Exceeded
Note For more information about hotfix 2553447, click the following article number to view the article in the Microsoft Knowledge Base:
2553447 MS12-046: Description of the security update for Office 2010: July 10, 2012


To resolve this issue, apply the following update:

2760394 Description of the Access 2010 hotfix package (ace-x-none.msp): October 30, 2012

Registry key information

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
After you install the hotfix package, to have us enable the hotfix for you, go to the "Fix it for me" section. If you prefer to enable the hotfix yourself, go to the "Let me fix it myself" section.

Fix it for me

To enable the hotfix, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.

For Windows 8

For Windows 7, Windows Vista, Windows XP, Windows Server 2008 or Windows Server 2003


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