Access: Not enough system resources - what to do?
If you receive the "Not enough system resources" error message in Access, you can fix it with just a few clicks. Find out what you need to do in this practical tip.
Access: "Not enough system resources" - you can do that
- Open the start menu and enter "msconfig" in the search field. Confirm with [Enter].
- Click on the "Start" tab and then "Advanced Options".
- In the next window, activate the "Maximum memory" check box.
- Also enter your maximum working memory in the field. We recommend at least 3 GB.
- Save the changes with a click on "OK".
We will show you how to compress databases in Access in the next practical tip.