SP表单集成Access数据库表 [英] SP form Integration to Access Database tables

问题描述

您好， 

我在Access中有报告实用程序，它依赖于存储在访问中的表信息。这些表由最终用户在Access表单中输入的数据填充。我希望这个表单在SharePoint（Web）中发布，而不是让最终用户在那台机器上安装Access
文件。 Web选项最为可取。话虽如此，我知道SP列表可以链接到SP Web的Access表，但我无法使同步工作，即如果SP列表或表单更新了数据，那么底层的
Access表也应该更新新信息。我缺少什么使这项工作？感谢您的帮助！

i have reports utility in Access that depend on table information stored in access. The tables are populated by data entered in Access forms by end users. I would like this form to be published in SharePoint (web) instead of having the end user install Access file on there machine. A Web option would be most preferable. Having that said, i am aware that a SP listing can be linked to Access table from SP Web but i couldn't get the synchronization working i.e if SP list or form is updated with data then the underlying Access table should also update with new information. What am i missing to make this work? Appreciate your help!

谢谢，

Vinny！

推荐答案

Sunvinmon， 

Hi Sunvinmon, 

要将访问表与SharePoint列表同步，您可以打开创建SharePoint列表，单击" ;使用Access打开：

To sync access table with SharePoint list, you can open create a SharePoint list, click "Open with Access":

然后选择"链接到SharePoint网站上的数据"：

Then choose "Link to data on the SharePoint Site":

现在它将SharePoint列表与访问表同步。 

Now it will sync the SharePoint list with the access table. 

最好的问候， 

Best Regards, 

Lisa Chen 

Lisa Chen 

这篇关于SP表单集成Access数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！