数据库只读连接访问 - sharepoint [英] Database read only connection access - sharepoint

问题描述

我在访问365和sharepoint 365之间有一个连接。当我启动updatequery到sharepoint时，我得到一个错误，数据库是只读的。 （从+/- 9000记录上传）。我在访问时取消选中缓存Web服务和sharepoint表，但这并没有帮助
。有人建议如何解决这个问题？

I have a connection between access 365 and sharepoint 365. When i start an updatequery to sharepoint i get an error the database is read only. (upload from +/- 9000 records). I unchecked caching web service and sharepoint tables in access but this didn't helped. Anyone a suggestion how to solve this issue?

推荐答案

你好Evy _，

Hi Evy_,

你是怎么做的？在Access 365和SharePoint 365之间创建连接？

How did you create a connection between access 365 and SharePoint 365?

您是如何启动SharePoint的upatequery的？

How did you start a upatequery to SharePoint?

您能否提供有关该更新的详细信息？问题？

Could you please provide more detailed information about the issue?

  要解决此问题，请查看以下内容：

 To troubleshoot the issue, check things below:

1。   在将表更新到列表时，检查SharePoint中的列表中是否存在元数据列。如果列表中有元数据列，我建议您删除元数据或使用其他列替换元数据
列。

1.  Check if there is metadata column in the list in the SharePoint online when you update the table to the list. If there is metadata column in the list, I suggest you could remove the metadata or use other column to replace the metadata column.

2。在计算机中重新安装Access 365或Office 365.

2. Re-install Access 365 or office 365 in the computer.

更多参考：

"无法更新。数据库或对象是只读的" Access中链接的SharePoint列表中的错误。

"Cannot update. Database or object is read-only" error in linked SharePoint list in Access.

https://support.microsoft.com/en-sg/help/3200680/cannot-update-database-or-object-is-read-only -error-in-linked-sharepoi

有一个类似的帖子：

https：//开头answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_winother/sharepoint-list-in-access-become-read-only/39ba0ea1-5daa-4e9a-b8d0-8510e57663e0

祝你好运，

Sara Fan

这篇关于数据库只读连接访问 - sharepoint的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！