How to Fix Microsoft Access Out of Memory Errors After an Office Update
Question details
Microsoft Access applications are throwing out-of-memory or system-resource errors following a recent Office update, despite having plenty of physical RAM.
- Product
- Microsoft Access
- Device & OS
- Windows
- Scenario
- Running 32-bit Microsoft Access databases after installing the December 6, 2022 Office update on the Current Channel.
- Observed behavior
- The application reports out-of-memory errors and memory usage spikes rapidly because it exhausts its 2 GB virtual address space limit, even if physical memory usage is low.
Verify whether your Office installation is 32-bit or 64-bit by checking the 'About' section in your Access Account settings, and save any open database queries to prevent data corruption during troubleshooting.
Switch to a Slower Office Update Channel
Rolling back from the Current Channel to a slower, more stable update channel can help bypass early-release bugs affecting system resources.
The Current Channel receives Microsoft Office updates as soon as they are available, which sometimes includes unresolved bugs like the virtual address space exhaustion in Access.
Moving your production systems to the Semi-Annual Enterprise Channel or rolling back to a previous build can instantly resolve the issue while Microsoft investigates the bug.
Click the Start menu, type 'cmd', right-click on 'Command Prompt', and select 'Run as administrator'.
Type 'cd %programfiles%\Common Files\Microsoft Shared\ClickToRun' and press Enter to access the Office update executable.
Run the command 'OfficeC2RClient.exe /changesetting Channel=SemiAnnual' to switch your update channel away from the problematic Current Channel.
Run the command 'OfficeC2RClient.exe /update user' to downgrade and apply the stable build to your Access application.
Upgrade to the 64-Bit Version of Microsoft Office
Upgrading removes the 2 GB virtual memory limitation entirely, allowing Access to utilize all available physical RAM on your system.
Switch to a Lightweight Office Suite to Avoid Performance Issues
If frequent Office updates, heavy resource consumption, and unexpected crashes are disrupting your daily workflow, consider switching to WPS Office. It provides a robust, lightweight environment for all your document, spreadsheet, and presentation needs without overwhelming your system's memory.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install WPS Office: Run the setup file and follow the quick installation prompts to install the suite on your computer.
- 3. Open Your Files: Launch WPS Office and instantly open your existing .docx, .xlsx, and .pptx files to continue working seamlessly.
Frequently Asked Questions
Why does Access say 'out of memory' when I have 16 GB of RAM available?
If you are running the 32-bit version of Access, the application is inherently restricted to about 2 GB of virtual address space. Once the application hits this internal 2 GB limit, it will trigger an out-of-memory error, regardless of how much physical RAM your computer actually has.
How can I check if my Microsoft Access is 32-bit or 64-bit?
Open Microsoft Access and create or open a database. Click on 'File' in the top-left corner, select 'Account' at the bottom left, and then click the 'About Access' button. The resulting pop-up window will prominently display whether your installation is 32-bit or 64-bit at the top.
What is Large Address Aware (LAA) in Microsoft Office?
Large Address Aware (LAA) is an executable flag that allows 32-bit applications to utilize up to 4 GB of virtual memory on 64-bit Windows systems, doubling the standard 2 GB limit. Microsoft has progressively enabled this for some 32-bit Office apps to help mitigate memory exhaustion errors.
