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.

Access encounters multiple issues if the PC has been running more than 20 days


View products that this article applies to.

Symptoms

Assume that the machine you are running Access on has been running more than 20 days. In this scenario, you may run into one or more issues.

1. Access may consume excessive CPU resources

2. Background tasks do not execute. For instance, domain functions (dlookup, dsum, dcount, etc) will not display a value.

↑ Back to the top


Cause

This is a known issue in Microsoft Access.

↑ Back to the top


Resolution

A hotfix has been created for Access 2010 to prevent the excessive CPU resources. Further details can be found in KB 2553296.

KB 2553296 Description of the Access 2010 hotfix package (Access-x-none.msp): December 11, 2012
http://support.microsoft.com/kb/2553296/EN-US

Currently there isn't a fix for the tasks that are intended to run in the background of the application. This will be reviewed for future versions of Access, but the current best practice guidance is to ensure that the PC has been rebooted at least once every 20 days.

↑ Back to the top


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

↑ Back to the top


Keywords: KB2827138

↑ Back to the top

Article Info
Article ID : 2827138
Revision : 1
Created on : 3/27/2013
Published on : 3/27/2013
Exists online : False
Views : 560