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
Feb 08 2023 11:20 PM
Feb 09 2023 01:20 AM
Feb 09 2023 01:38 AM
Feb 09 2023 02:03 AM
Are you sure that in sharepoint in your sharepoint lists there are no dropdown lists? If yes, than Sharepoint have created a relation with that table on the background.
Feb 09 2023 02:15 AM
Feb 09 2023 03:02 AM
Feb 09 2023 06:33 AM
Feb 09 2023 10:50 AM - edited Feb 09 2023 10:58 AMSolution
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
Me.Recordsource = "shp_tblName"
Feb 09 2023 10:17 PM
Feb 10 2023 03:42 AM - edited Feb 10 2023 03:46 AM
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.
Feb 11 2023 08:11 AM
Feb 12 2023 07:39 AM
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.