Forum Discussion
Sharepoint list update is not working sometimes
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 iMe.Recordsource = "shp_tblName"
Servus
Karl
****************
Access Bug Trackers
Access News
Access DevConMe.Refresh
What does it mean to say that you want to "update" a SharePoint list? What, exactly, is supposed to be changed? How is it to be changed?
Show us the actual VBA code; we can't see it unless you provide a copy to look at.
- Hello George,
thanks for the fast reply.
I am trying to update the sharepoint field (see the code below)
For i = 0 To UBound(arr_iID) - 1
CurrentDb.TableDefs("shp_Bestellformular").RefreshLink
CurrentDb.Execute "Update shp_tblName set Bestätigung_um = '" & Now & "' where ID = " & arr_iID(i) & " "
Me.Refresh
Next i
Sometimes, some elements gets updated sometime, nothing gets updated.
BR- Why do you think you need to refresh the link before executing the update query? What's the problem you are trying to solve with that?
The actual update looks appropriate except for one thing. It's a good idea to include dbFailOnError to cause an error message to be returned if an update fails. That way you know what actually caused it "not to work".
CurrentDb.Execute "Update shp_tblName set Bestätigung_um = '" & Now & "' where ID = " & arr_iID(i) & " ", dbFailOnError
If the update doesn't raise an error, it silently moves on.- THanks this comand helped me , dbFailOnError
now i recieved the error after 2-3 Updates like:
Error3218: Update not possible while at the moment blocked
