MS-ACCESS "System resource exceeded"

https://www.windowscentral.com/assign-specific-processor-cores-apps-windows-10

https://social.technet.microsoft.com/Forums/office/en-US/5828a030-f27f-4001-9aaa-8d2951ef4169/quotsystem-resource-exceededquot-for-simple-select-query-in-access-2013?forum=officeitpro

 

So in my case (Windows 10):

1) Control-alt-calc and choose Task manager

2) Go to Details tab and right-click on MSACCESS.EXE

3) Choose SET AFFINITY

I think this will let the computer to use most energy/memory/effort only on that software.

I have not tested this yet.