Microsoft Access System Resources Exceeded with Sharepoint Lists

Question

Hi
I have an Access front-end with a number of action queries linked to Sharepoint Lists (basically the back-end).
On a monthly basis, I run a number of action queries to refresh the data stored in the lists. Normally, I would get the occasional Systems Resources Exceeded error whilst running the queries, but now it seems that it happens all the time.

Has there been a recent update or change to how Sharepoint Lists work? I know the optimal setup would be to have SQL Server for the backend, but I would need to probably have a business case to propose this as well as that I have no clue where to start to make the change.

Could someone provide some insight to this? I would like to see if I can tweak the management of memory when the queries are running within the Access front-end via VBA but I haven't had much success.

thanks!

Answer 1

So the first query fails with SRE. Let's focus on that one, and slice and dice it several ways:
1: update half the fields, then in a second query update the other half
2: update half the rows, then in a second query update the other half.
What is the result of that?