断开连接后与Sharepoint（VBA）同步
您好
我有一个SharePoint（2013）数据库，并使用 Access（2013） 作为前端。我使用来自VBA（CurrentDb.Execute txtSQL）的SQL更改了SharePoint列表的内容。
I have a SharePoint (2013) database and use Access (2013) as front end. I change the contents of the SharePoint list using SQL from VBA (CurrentDb.Execute txtSQL).
很多时候，Access失去了与SharePoint的连接，我收到错误3981.之后用户看到了功能区中的按钮，使他能够手动将Access与SharePoint同步。
Very often Access loses connection to SharePoint and I get error 3981. Afterwards the user sees a button in the ribbon, which enables him to manually synchronize the Access with SharePoint.
我的问题：如何使用VBA将Access与SharePoint同步，以便用户不必执行此操作手动并没有注意到连接错误？
My question: how to synchronize Access with SharePoint with VBA, so that the user doesn't have to do this manually and doesn't notice that there was a Connection error?
我错过了一些像"同步"这样的VBA指令或类似的东西...我只找到了"DoCmd.RunCommand acCmdSynchronize"但它不起作用......
I miss some VBA instruction like "synchronize" or something like this... I only found "DoCmd.RunCommand acCmdSynchronize" but it doesn't work...
有人可以帮助我吗？
亲切的问候，
Agnieszka
Agnieszka
当你说acCmdSynchronize不起作用时，是你的知道有一个活动的SharePoint连接？否则，如果没有与服务器的活动连接，我不确定如何与SharePoint同步。
When you say acCmdSynchronize does not work, was it when you know there is an active connection to SharePoint? Otherwise, I am not sure how you can synchronize with SharePoint if there is no active connection to the server.
好奇......