Sharepoint MsAccess同步 [英] Sharepoint MsAccess synchronization

问题描述

嗨！ 有谁知道如何将MS Access数据同步到SharePoint门户.我想将两者链接在一起，并在收到新的数据条目时触发工作流程.

HI! Does anyone have any idea how to synchronize MS Access data to SharePoint portal. I would like to link both of this together and trigger a workflow upon receiving a new data entry.

希望您可以提出建议. 谢谢！

Hope you could advice on it. Thanks!

推荐答案

该过程涉及将访问表迁移到SharePoint.因此，如果您在Access to SharePoint中移动或迁移了表，然后选择链接表，则它是到SharePoint的实时连接.这是该表的双向语法.因此，Access中的任何更改(对该链接表的任何更新)都将看到更改发送到SharePoint中的同一表(列表).然后尝试同步整个文件是一个非常不同的过程.因此，powerpoint文件甚至Access文件在FILE级别上都无法正常工作，并且您无法获得任何类型的多用户设置.

The process involves migrating your access tables to SharePoint. So if you moved or migrate a table in Access to SharePoint AND THEN choose to link the table, then it is a live connection to SharePoint. This is a bi-direction synnc of that table. So any change in Access (any update to that linked table) will see changes sent to the same table (list) in SharePoint. This is a VERY different process then trying to sync a whole file. So power-point files, or even a Access file does not work well at the FILE level, and you don't get any kind of multi-user setup.

但是，如果将表迁移到SharePoint列表，则在Access中针对该链接表构建的任何SQL查询都可以正常工作.其中包括追加查询，更新查询或仅选择数据.

However, if you migrate the tables to SharePoint lists, then any sql query you build in Access against that linked table will work just fine. And that includes append query, update query, or just a select for data.

您甚至可以离线模式对这些链接表进行处理.这意味着即使没有网络连接，您也可以继续更新表.当您最终获得Wi-Fi或某些Internet连接时，数据将自动(双向)同步，并且表格将更新丢失或更改的数据.

And you can even work against these linked tables in off-line mode. This means that you can continue to update the tables even without network connection. When you do finally get wi-fi or some internet connection, then the data will auto-sync (both ways) and tables will update missing or changed data.

请注意，您甚至可以迁移和维护相关数据，SharePoint现在支持并维护这些关系(使用Access 2010(或更高版本)和SharePoint 2010(或更高版本)时，表之间的引用完整性得到支持.

Note that you can even migrate and maintain related data, and SharePoint now supports relations and maintains those relations for you (referential integrity between tables is supported when using Access 2010 (or later) and SharePoint 2010 (or later).

迁移相关表需要非常小心的步骤. Access将迁移相关数据表并将其发送到SharePoint(并为您维护关系).您只需确保您的关系是SharePoint支持的类型.

VERY careful steps are required to migrate related tables. Access will migrate and send related tables of data to SharePoint (and maintain the relations for you). You simple have to ensure that your relations are of a type that SharePoint supports.

这意味着您的PK必须是自动编号ID类型，外键必须是标准的长数据类型.由于此设置是Access关系的绝大部分，因此这些类型的相关表可以很好地移动到SharePoint.但是，如果您说的PK/FK设置是字符串，则这种关系在SharePoint中不起作用.

This means your PK has to be a autonumber ID type, and the foreign key has to be standard long data type. Since this setup is the vast majority of Access relationships, then these types of related tables move rather well to SharePoint. However, if you PK/FK setup is say a string, then such relationships don't work in SharePoint.

另一个问题是要记住，当使用Office 365或托管的SharePoint的行数超过5000行时，可能会出现性能问题.如果您的SharePoint系统处于本地，则可以关闭其中一些限制.

The other issue is to keep in mind that performance issues can arise when the row count exceeds 5000 rows when using Office 365 or hosted SharePoint. If your SharePoint system in on-premises then you can turn off some of these limits.

迁移相关数据表很容易，但是在大多数情况下，您需要确保使用表查找向导来设置关系.有时您可以使用关系窗口，但是在大多数情况下，在将表迁移到SharePoint之前，您需要以正确的方式重新构建关系.如果您没有相关数据，只有几个表，那么在迁移此类表之前，您实际上不需要在Access中做任何事情.

Migration of related data tables is easy, but you need to ensure you setup the relationships using the table lookup wizard in most cases. Sometimes you can use the relationship window, but in most cases, you need to re-build the relationship in a correct way BEFORE you migrate the tables to SharePoint. If your don't have related data, and just a few tables, then you don't really have to do much of anything in Access before you migrate such tables.

如前所述，一旦迁移到SharePoint，则针对此类链接表执行的所有sql查询都可以正常工作.因此，无需在本地或SharePoint上更新表-整个过程是全自动的，并为您同步.

As noted, once migrated to SharePoint, then any sql query you execute against such linked tables will work fine. So no need to update the table local, or on SharePoint - the whole process is fully automatic and synced for you.

此视频显示了在您需要的情况下如何将相关数据表迁移到SharePoint:

This video shows how to migrate related data tables to SharePoint if that is your requirement:

https://www.youtube .com/watch?v = 3wdjYIby_b0& t = 0s& list = PL27E956A1537FE1C5& index = 3

鉴于标记是针对SharePoint 2007的，那么您将发现需要访问2010(或更高版本)和SharePoint 2010(或更高版本)才能使参照完整性起作用.在Access 2010之前的版本中，您发现链接列表的性能相当慢，并且表行数必须保持较小. (低于10,000行).

Given that the tags are for SharePoint 2007, then you will find that access 2010 (or later) and SharePoint 2010 (or later) is required for referential integrity to work. And pre Access 2010, you find performance of linked lists to be rather slow, and table row counts needs to be keep small. (under 10,000 rows).

这篇关于Sharepoint MsAccess同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！