Forum Discussion

Tin Contributor

Nov 12, 2020

Solved

Access connected to sharepoint list

Hi I have 2 list I update from Access to sharepoint. First list I run 3 query (Add, Update, Delete) no problems. Second Liste the same 3 query (Add, Update, Delete). When i come to the last ...

office 365

sharepoint

thansson
Dec 06, 2020
George_Hepworth

It is working if I only choose 50 Rows each time

Thank you and Merry Christmas

George_Hepworth

Silver Contributor

Nov 13, 2020

thansson

One possibility, based on that brief overview, is that the SharePoint list is still being locked from the previous query while some process continues, possibly re-indexing or something like that. What happens if you wait longer between running the various queries?

How many records are in these lists? SharePoint is definitely handicapped when processing larger lists. The exact meaning of "larger" can be flexible but anything over 5,000 records might be venturing into that territory. Definitely anything over 25,000 records in a SharePoint list is going to be suspect--performance wise.

thansson

Tin Contributor

Nov 13, 2020

Hi George_Hepworth

tks for your anser.

Numbers of Rows is different each time, but around 3000 Rows.

It dont help if I am waiting, if I close access and reopen, and only run the last query, still the same. If I keep on running the query it Will loose connection, and after that the query has Been executed.

It is Strange it has Been working for a while without problems.