Forum Discussion
system resources exceeded error
gnarlesv . I have an update on this issue. It seems related, either to my updating to the most current windows feature update or to a windows update that might have happened just prior to that. In any event, the error persists with the most current windows, windows features, and access versions. when i moved my tables to a local postgres database and connected to the tables via odbc, the systems resources error when away. I also moved my databases to my old laptop, also a lenovo thinkpad, which had not be upgraded to the most current windows, features, and access versions and the queries run just fine. My IT guys are trying to roll back the computer that has been having the issues. I will keep everyone post.
gnarlesv yes, this is when it started for me. Last Thursday week, MS updated Win 10, and they also have me Office 365 (for no apparent reason Office 365 went off my system on Wednesday, whether MS did it in the background I don’t know). I use Office 2016 Professional, and now my machine is running Office 2016 Professional again. The issue still remains.
To get around resources exceeded problem, I have had to write code to work around queries and table updates to my archive table. This is unsatisfactory. The database is made to query data, not to fail because of record count. My code is failing in many spots and it is extremely difficult to do work arounds.
I did find that some of the “exceeded” errors can be prevented by closing other MS apps. I almost got through an entire process after closing teams, outlook and excel.That is unsatisfactory. I didn’t buy a good quality computer to have to close applications to be able to use Access.
If unwinding the update resolves the problem, I’m eager to hear.
