Sharepoint List后端允许添加新记录，但在编辑现有记录时会挂起 [英] Sharepoint List backend allows adding new records but hangs when editing existing records

问题描述

您好我有一个Access 2013前端指向Office365 Sharepoint Online后端。

当我将Backend移动到Sharepoint时，向导报告它已成功上传。  但是，有两个表，它们是最大的主表，不允许编辑任何现有记录。  如果您编辑它们，
蓝色圆圈旋转，您必须按CTRL ALT DEL才能关闭Access。

我可以直接在SharePoint中访问列表时编辑表格使用浏览器。  我还可以使用Access和Sharepoint编辑所有其他表。  奇怪的是，我可以向所有表添加新记录，包括导致Access在编辑时崩溃的问题
。  

任何想法？

谢谢！

PS缓存/不缓存似乎没有做出改变。  虽然勾选"使用与Microsoft Access 2010及更高版本兼容的缓存格式"会导致出现各种错误。

解决方案

Hi AccessDatabase，

>>有两个表，它们是最大的主表，不允许任何现有记录被编辑

您用来编辑的表格这两张桌子？我认为它可能与你的表格有关。为了缩小这个问题，我建议你根据这两个表创建一个简单的表单来检查这个问题是否仍然存在。如果它不存在，我会
建议您检查原始表格中的代码。

此外，根据您之前的帖子，我建议您检查是否使用Office 365帐户登录Access FE。

最好的问候，

Edward

Hi I have an Access 2013 front-end pointing at an Office365 Sharepoint Online backend.

When I moved the Backend to Sharepoint the wizard reported that it had uploaded successfully.  However, there are two tables, and they are the largest main tables which won't allow any of the existing records to be edited.  If you do edit them, the blue circle spins and you have to CTRL ALT DEL to close Access.

I can edit the tables when accessing the lists directly in SharePoint using a browser.  I can also edit all the other tables using both Access and Sharepoint.  The strange thing is that I can add new records to all the tables including the problem ones that cause Access to crash when editing.  

Any ideas?

Thanks!

PS Caching/Not caching doesn't seem to make a difference.  Although ticking the 'Use the cache format that is compatible with Microsoft Access 2010 and later' causes all sorts of errors to crop up.

解决方案

Hi AccessDatabase,

>> there are two tables, and they are the largest main tables which won't allow any of the existing records to be edited

Which forms you used to edit these two tables? I assume it might be related with your form. To narrow down this issue, I would suggest you create a simple form based on these two tables to check whether this issue still exist. If it did not exist, I would suggest you check the code in original forms.

In addition, based on your previous thread, I suggest you check whether you log in Access FE with Office 365 account.

Best Regards,

Edward

这篇关于Sharepoint List后端允许添加新记录，但在编辑现有记录时会挂起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！