Forum Discussion
system resources exceeded error
gnarlesv This is the same issue I have. MS will not help me. My system was upgraded yesterday and since then my Access code is failing due to this error. I thought my table was corrupted. After rebuilding it and removing all bar 100,000 records, it still does it. There is something dreadfully wrong with probably Win 10 as this problem only appeared rarely in Access since the W10 update. My access table which is called when the system resources exceeded error occurs had 386,000 records before W10 update, but after W10 update, it now stops. As I said, I culled it back to 100,000 records and for some code, it runs, but for others it now stops with that error. The program DOES NOT WORK, and MS does not want to help. I support your complaint.
I'll bring this problem to the attention of the MS Access team to see if they are aware of it and if there is a potential fix to address it.
This is a known problem but up until recently, it's been unresolved. However, "... there is a fix for this in version 2010, which is currently available for Office Insders, and will be in Current Channel at the end of this month.
So if you know of instances where this is happening, please try version 2010 if you can to see if it resolves the issue."
George
George_Hepworth Do you have a source link for the known issue status and upcoming Current Channel fix? We have had some success changing processor affinity in the past, but are now seeing these system resources exceeded errors frequently regardless of our affinity settings. (A365, version 2008) I don't see this issue mentioned in the beta or current (preview) channel https://docs.microsoft.com/en-us/officeupdates/update-history-beta-channel.
Thanks!
