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
Feb 01, 2023
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 01, 2023
  Hi George,
  
  The report today was only about Sharepoint because they have their entire backend on it. I'm doing a little digging for more reports on this. If you know of any, please let me know. This discussion here doesn't seem to hit it, as Arslan replied that he's using Win10.
  
  Servus
  Karl
  ****************
  Access Bug Trackers
  Access News
  Access DevCon
  - AAB_786
    Copper Contributor
    Feb 03, 2023
    Hello Karl,
    
    I have a feeling,, if the cursor is on some recordset then it gets locked, and let not update.
    
    But i applied all the different ways but unfortunately not successfull.
    
    Is there anyway to move the curso to some other recordset?
    
    BR
    Arslan
AAB_786
Copper Contributor
Feb 01, 2023
Hello dear,

no i am not using Windows 11, it is Windows 10. As the connection is also not getting lost, but the recordsets get locked, after second, third time it works.

Servus
Arslan

Forum Discussion

Sharepoint list update is not working sometimes

Share

Resources