Article ID: 2726928 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

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

Resolution

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

Collapse this imageExpand this image
assets folding start expanded
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
Collapse this imageExpand this image
assets folding start expanded
Collapse this imageExpand this image
assets fixit1
Fix this problem
Microsoft Fix it 25014
Collapse this imageExpand this image
assets fixit2

Collapse this imageExpand this image
assets folding end

For Windows 7, Windows Vista, Windows XP, Windows Server 2008 or Windows Server 2003
Collapse this imageExpand this image
assets folding start expanded
Collapse this imageExpand this image
assets fixit1
Fix this problem
Microsoft Fix it 55035
Collapse this imageExpand this image
assets fixit2
Collapse this imageExpand this image
assets folding end

Notes
Collapse this imageExpand this image
assets folding start collapsed
  • Install hotfix that is described in Microsoft Knowledge Base (KB) article 2760394 before you run this Fix it solution.
  • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
  • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
  • We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me" blog or send us an email message.
Collapse this imageExpand this image
assets folding end collapsed
Collapse this imageExpand this image
assets folding end

Let me fix it myself

Collapse this imageExpand this image
assets folding start collapsed
After you install the hotfix package, follow these steps to enable the hotfix:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then click one of the following registry subkeys:
    • On 32-bit versions of Access on 32-bit versions of Windows or 64-bit versions of Access on 64-bit versions of Windows:
      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines
    • On 32-bit versions of Access on 64-bit versions of Windows:
      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines
  3. On the Edit menu, point to New, and then click DWORD (32-bit) Value.
  4. Type WorkingSetSleep, and then press Enter.
  5. In the Details pane, right-click WorkingSetSleep, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.
    Collapse this imageExpand this image
    assets folding end collapsed

Status

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

Properties

Article ID: 2726928 - Last Review: February 19, 2013 - Revision: 3.0
Applies to
  • Microsoft Access 2010
Keywords: 
kbqfe kbsurveynew kbexpertisebeginner kbfixme kbmsifixme KB2726928

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com