Forum Discussion

Copper Contributor

Jan 29, 2023

Sharepoint list update is not working sometimes

Hello all, I have a sharepint list, and updating the list using access vba. I have a problem sometime the update works and sometimes it doesnot works, i have been trying to solve this problem usi...

MS Access

VBA

Karl_Donaubauer
Feb 09, 2023
Hi,

Do I understand the situation in your application right?

1. You have a form with a linked Sharepoint list as recordsource.

2. From within this form with a button or sth you are trying to update several records of the same list with your DAO.Execute statement.

3. You get error 3218 and you think it occurs for the currently active record in the form.

If that's correct then I would

a) not do a Refreshlink for the list or Refresh on the form in every iteration of the loop where you do the Execute.

b) try if the updates work when you disconnect the form from the list while executing the update statement. Just as a hard test if the form is the culprite:

Me.Recordsource = ""

For i = 0 To UBound(arr_iID) - 1
CurrentDb.Execute "Update shp_tblName set Bestätigung_um = '" & Now & "' where ID = " & arr_iID(i), dbFailOnError
Next i

Me.Recordsource = "shp_tblName"

Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon

Me.Refresh

George_Hepworth

Silver Contributor

Karl, do you have any indication that this impact other applications, or only Access/SharePoint applications? It appears to be a Windows 11 "anomaly", but it's not clear if it is specific to the Access and SharePoint configuration.

Karl_Donaubauer

MVP

Feb 10, 2023

Hi George_Hepworth ,

My Windows 11-related query was obviously about a different Sharepoint problem. Just as a follow-up that might help somebody else:

The company affected by frequent but irregular interruptions to Sharepoint informed me that the problems were most probably caused by the "Dell Optimizer". At least things have been running for 3 days without problems since they uninstalled that tool. According to Dell:

"Dell Optimizer is a software application that intelligently and dynamically optimizes the performance of your computer by using artificial intelligence(AI) and machine learning(ML)."

Fascinating what all unexpected and hard to detect can be involved in such problems.

Servus
Karl
****************
Access Bug Trackers
Access News
Access DevCon

AAB_786
Copper Contributor
Feb 11, 2023
Hallo Karl,

Thanks for your tip, at the moment it works fine. Now I have a problem after Me.Recordsource=" move the cursor to first RS. Is there any solution which let the RS stay on the same position.

Thanks
- Karl_Donaubauer
  MVP
  Feb 12, 2023
  Hi,
  
  You can use code similar to my FAQ 4.5 to go back to the same record as before.
  
  I assume that you understand German as there's some in your code. Even if not you can just take the code from there. Your current code then practically replaces the Requery line in the FAQ example.
  
  Servus
  Karl
  ****************
  Access Bug Trackers
  Access News
  Access DevCon