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
I have no dropdown lists in Sharepoint list, i have only checkboxes and some text fields in sharepoint list, and it's not too long and also have may be 20 Recordsets.
2. Don't use: CurrentDb.TableDefs("shp_Bestellformular").RefreshLink. You don't need this if there aren't design changes of your table.
3. Try for test to edit values in the link table directly. Sometimes the record lock could occur on a specific record.
- 1. I changed it from Numeric to YES / NO
2. I commented it.
3. Local works always.
And your 1 & 2 i have changed still no difference.
any other idea?