Fix System Resource Exceeded error with large files
Ever since we upgraded to the latest Windows 10 version and MS 2019 version, our previously working update queries for ~100,000 records are failing and throwing the System Resource Exceeded error! This is unacceptable.
The issue is reproducible on multiple computers with the latest upgrade and working on the non-upgraded computers. Many users are suffering from this issue as you can see here: https://techcommunity.microsoft.com/t5/access/system-resources-exceeded-error/m-p/1791077
Swap to a mysql backend?