Forum Discussion
system resources exceeded error
I have just experienced what I believe to be the same error on the Siemens WinCC application (used for making industrial user interfaces).
The WinCC runs in a Win10 as the only application (except for what else is running on a Windows PC), but it uses a number of MS-Access-files through ODBC where these .mdb-files are registered as data sources.
I believe the behaviour is related to Win10. I have had the same application run on Win7 for many years without any such issues.
I can have the code trap the error "Error #-2147024882: [Microsoft][ODBC Microsoft Access Driver] System resource exceeded" - and make a reboot of the system - which solves the problem (for a while).
The just experienced incident is on a Windows 10 Pro, version 2004
I believe it has also happened on a Windows 10 Pro, version 1903, but here I did not have proper logging of errors set up, so I don't know for sure.
Anyway - I hope a fix for Win10 will address this soon - and then I need to find a way to install that on installations with no internet-access.
In the meantime I guess, I'll make logic to perform a reboot in case this error occurs...
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.
