Forum Discussion
system resources exceeded error
Jake104E thanks.
I think also that W10 is the problem.
It first started when W10 had an update on my computer, but at the same time, MS updated Office (to an Office 365 version). The W10 update was in October.
I do not own Office 365 and a number of days later, the Office 365 version disappeared (I don’t know how, but didn’t bother to research), and my Office returned to the version.
After the initial update, the system resources error appeared, and has remained.
The error comes when my VB code is accessing large data tables. I closed Teams, Outlook, Excel and Word, then ran my access code, and it went through without error.
In an another run, accessing a different larger table, the error appeared though.
Since my access has not been changed, the problem can only be W10.
NevilleA This worked for me... I had MS ACCESS DB located in the area that is set to use OneDrive. I moved the DB to an area that is not part of OneDrive and did not receive the error.
rtdavis3 Thanks. It’s good you found a fix. I don’t use OneDrive however, so my error persists.
I found a workaround. You need to to run the program as an administrator which, I speculate, frees up resources and the error stops.
Here are the steps to run the program as an administrator. Start by copying your database/file location:
- Right-Click on the desktop -> New -> Shortcut
- Paste in your file location.
- Name shortcut
- Right-Click on the new shortcut -> Properties
- Click Advanced
- Check “Run as Administrator”
- Apply
NOTE: When I first start the program I get "system resources exceeded". I close the program and re-open and it works fine. Not sure why I have to open, then re-close, for it to work.
