Microsoft Access System Resources Exceeded with Sharepoint Lists

A Nasar 1 Reputation point
2021-10-07T15:50:13.003+00:00

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!

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
SharePoint
SharePoint
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
    2021-10-11T14:02:16.677+00:00

    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