通过Access 2013更新链接的Sharepoint表导致崩溃 [英] Updating linked Sharepoint tables via Access 2013 causing crashing

问题描述

我正在通过Access 2013更新SharePoint 2010表。我已经尝试使用更新查询 - 我收到的消息是只有在没有明确的情况下才读取对象 - 我可以手动更改值在细胞中。所以我是以编程方式进行的。 

I am updating a SharePoint 2010 table via Access 2013. I have tried it using an update query - I was getting the message that the object is read only when clearly it wasn't - I can manually change the values in the cells. So I am doing it programatically. 

我可以看到循环更新一些单元格，但在更新记录时不可避免地会在某些时候导致Access中的硬崩溃。有时它是在2条记录之后，有时是在100之后。我怀疑它与服务器连接的质量或超时，
或类似的东西有关。

I can see the loop update a few cells, but inevitably at some point while updating a record it causes a hard crash in Access. Sometimes it is after 2 records, sometimes after 100. I suspect it is linked to the quality of the server connection, or a timeout, or something like that.

任何想法该怎么做？

提前致谢！

推荐答案

根据您的描述，您使用VBA宏中的Update语句更新链接的SharePoint列表表，但代码始终使Access崩溃。

According to your description, you update a linked SharePoint list table with Update statement in a VBA macro but the code always make Access crash.

崩溃发生在某些特定记录或不规则记录中吗？

Does the crash happen in some specific records or in irregular records?

我无法在Access 2013中重现您的问题，而且我不确定您的表的数据结构和更新声明，您介意为我们分享您的示例表和代码吗？重现你的问题？

I failed to reproduce your issue in my Access 2013 and I’m not sure about the Data structure of your table and your update statement, would you mind sharing your sample table and code for us to reproduce your issue?

顺便说一下，我建议你安装
Microsoft Office 2013 32位Service Pack 1或
64位以查看问题是否可以解决。

By the way, I suggest you installing the Service Pack 1 for Microsoft Office 2013 32-bit or 64-bit to see whether the issue can be resolved.

Sub UpdateX()

    Dim dbs As Database
    Dim qdf As QueryDef

    Set dbs = CurrentDb
    
    dbs.Execute "UPDATE Table1 " _
        & "SET Field1 = 100 ;"
        
    dbs.Close
End Sub

这篇关于通过Access 2013更新链接的Sharepoint表导致崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！