Unfortunately I don't have an explanation, but ran into a similar problem this week.
This simple SQL, which is being generated via VBA, fails with a System Resource Exceeded error message on my work machine (i7, 16GB, Win 10, Access 365 64-bit):
SELECT SIGHTING_ID, LOCN_PRECISION...