Microsoft Access System Resources Exceeded with Sharepoint Lists

A Nasar 1 Reputation point

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.


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,318 questions
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,249 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Tom van Stiphout 1,701 Reputation points MVP

    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?

    0 comments No comments