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

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.

This is a known issue in Microsoft Access.

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.

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.