Office Performance Issues

Fix Not Enough Free Memory Error in Microsoft Access

Chanuka Geekiyanage Oct 15, 2026 869 views

Question details

The user needs to resolve an error stating there is not enough free memory to update the display in Microsoft Access.

How to Fix the 'Not Enough Free Memory' Error in Microsoft Access

Product: Microsoft Access for Microsoft 365
Device & OS: not provided
Scenario: Performing multiple searches using the Find and Replace dialog within a specific database and form.
Observed behavior: Access displays the message 'There isn't enough free memory to update the display' and fails to complete the operation.

Before you start

Ensure you have saved all pending work in other open applications, as resolving this memory issue may require restarting your computer or virtual desktop session.

Solution 1Recommended

Restart Microsoft Access and the Computer

Restarting clears temporary memory and resets the display state, which is especially effective for virtual machines or remote desktop (RDP) sessions.

This error frequently occurs after an application has been running overnight or for extended periods in an RDP session or virtual machine due to temporary memory leaks.

Close Microsoft Access

Save your current database if possible, and completely close the Microsoft Access application.

Restart your system or session

Restart your local computer. If you are using a Remote Desktop connection or a Virtual Machine, log out of the session and restart the virtual environment.

Reopen the database

Launch Microsoft Access again, open the database, and attempt the Find and Replace operation to see if the memory error is resolved.

Solution 2

Run Compact and Repair Database

Use this built-in tool to eliminate file corruption and optimize performance if the error consistently affects a single database and form.

Solution 3

Investigate Forms, Linked Tables, and Indexes

Optimize the database structure to prevent excessive memory consumption during complex search-and-replace operations.

Free Microsoft Office alternative

Experience Lightweight and Stable Performance with WPS Office

If you frequently encounter memory errors or performance bottlenecks with heavy desktop applications like Microsoft Office, consider switching to WPS Office. It offers a lightweight, highly compatible alternative for processing documents, spreadsheets, and presentations without draining your system resources.

Lightweight architecture ensures minimal memory consumptionFully compatible with Microsoft Word, Excel, and PowerPoint file formatsAll-in-one tabbed interface for seamless multitasking across document typesFree to use with familiar features and no steep learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Access show a memory error only in Remote Desktop (RDP) sessions?

RDP and virtual machine sessions manage display memory differently than local machines. Leaving Access running overnight in these environments can cause temporary memory or display state leaks, triggering the 'not enough free memory' error. Restarting the session usually resolves it.

Can the number of records cause the 'not enough free memory' error?

Yes. Running search-and-replace operations on tables with a massive number of records—especially if the fields are unindexed—can consume significant memory and lead to this error.

What does the Compact and Repair tool do in Access?

The Compact and Repair tool reclaims unused space left by deleted records, reorganizes data for faster access, and fixes minor structural corruptions. Running it regularly can prevent performance issues and memory spikes.

Why does this memory error only happen on one specific form?

If the error is isolated to a single form, it is likely due to an overly complex record source query, unindexed fields, or corrupted form elements. Investigating the form's design and simplifying the underlying queries can help.

Office App Problems