Sharepoint 2007与Access 2007的集成 - 架构没有改变，为什么Access认为它是？ [英] Sharepoint 2007 integration with Access 2007 - Schema's not changed, why does Access think it is?

问题描述

问候，

我有一个基于SharePoint 2007构建的自定义业务应用程序（库目录），可将其数据保存在一系列SharePoint列表中。

I have a custom business application (a library catalog) built upon SharePoint 2007 that keeps its data in a series of SharePoint Lists.

我一直在使用Access 2007（以及最近的Access 2010）作为更新列表中数据的前端，因为它比通过Web UI进行更改更有效。 这很有效，除了一个令人沮丧的错误。 每次打开
连接到SharePoint列表并尝试编辑它们的数据库时，Access都会告诉我，"此表的架构已更改。 您必须在编辑或添加新记录之前刷新表格。"问题是Access正在撒谎 - 架构
没有更改。 刷新列表可以解决问题，但考虑到没有人在更改SharePoint站点上的架构，如果我可以更新列表而不必每隔
时间刷新列表就会更好数据库。

I have been using Access 2007 (and more recently, Access 2010) as a frontend to update data in the lists because it's more efficient than making changes through the web UI.  This works great, except for one frustrating error.  Every time I open a database that connects to the SharePoint Lists and attempt to edit them, Access tells me, "The schema for this table has changed.  You must refresh the table before editing or adding new records." The problem is that Access is lying -- the schema hasn't changed.  Refreshing the list fixes the problem, but given the fact that nobody is changing the schema on the SharePoint site, it would be a lot better if I could update my lists without always having to refresh the lists every time I launch the database.

鉴于架构没有改变，这里实际发生了什么，以及如何让Access在每次我想要更新我的时候停止向我发送此错误SharePoint列表？ 或者，每次打开数据库时，如何自动刷新列表
？

Given that the schema is not changing, what is actually going on here, and what can I do to get Access to stop throwing this error at me every time I want to update my SharePoint Lists?  Alternatively, how would I go about making the lists refresh automatically every time I open the database?

谢谢，

Marijane White

Marijane White

推荐答案

嗨Marijane，

Hi Marijane,

我试图复制你的问题，但它按预期工作。

I tried to reproduced your issue but it worked as expected.

只有您的Access 2007出现此问题吗？

Did only your Access 2007 appear this issue?

我建议您修复Office，然后删除链接表并重新链接列表在Access中，并检查结果。

您可以检查12 \ LOGS文件是否有一些有用的错误信息。

I would suggest you to repair the Office, then delete the linked table and re-link the list in Access, and check the result.
And you can check the 12\LOGS file whether there were some useful error information.

谢谢，

Daniel

Thanks,
Daniel

这篇关于Sharepoint 2007与Access 2007的集成 - 架构没有改变，为什么Access认为它是？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！