断开连接后与Sharepoint（VBA）同步 [英] Synchronizing with Sharepoint (VBA) after loosing connection

问题描述

您好

我有一个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.

好奇......

这篇关于断开连接后与Sharepoint（VBA）同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！