Jan 29 2023 10:51 AM
Jan 29 2023 10:51 AM
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 using different commands like CurrentDb.TableDefs("shp_table").RefreshLink but unfortunately its not working.
I am using a loop with maybe 5 recordsets, sometime 4 gets updated, sometimes 5 my update command is right. Do you have some possible solution for this?
many thanks in Advance
Jan 29 2023 10:59 AM
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.
Jan 29 2023 11:05 AM
Jan 29 2023 11:26 AM
Jan 29 2023 11:37 AM
Jan 29 2023 11:43 AM
That error suggests that one record--the one which failed to update--is currently being edited in a form, and is therefore locked. Does that make sense in the context where you are trying to run this update?
Perhaps you can resolve the problem by adding this line to the code. It will save the current record if it is being edited when the update runs. If it is the record that is blocking the update, that should resolve the problem.
If Me.Dirty Then Me.Dirty = False
For i = 0 To UBound(arr_iID) - 1
CurrentDb.Execute "Update shp_tblName set Bestätigung_um = '" & Now & "' where ID = " & arr_iID(i) & " "
Jan 29 2023 11:45 AM
Jan 29 2023 12:08 PM
Jan 30 2023 03:44 AM
Jan 30 2023 06:04 AM
Feb 01 2023 08:05 AM
Are you on Windows 11 by chance?
I ask because I just got off the phone with someone who reported similar sounding "disruptions" to Sharepoint 365 for about 3 months, and according to him only on the Windows 11 systems. On the Win10 machines, everything works as it has for years.
Feb 01 2023 09:00 AM
Feb 01 2023 09:10 AM
Feb 01 2023 09:19 AM - edited Feb 01 2023 09:54 AM
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.
Feb 02 2023 11:45 PM
Feb 08 2023 09:34 AM