Asked by:

Question

I am assessing the feasibility of migrating some of the core tables in a department MS Access relational database to lists on Microsoft SharePoint server in order to expand accessibility to users and improve security by keeping core data stores on the sharepoint
server rather than in a MS Access database on a file server. We would still maintain a baseline access database that is linked to the sharepoint lists for running append queries, update queries, and other additional features for select users to
maintain and update data.

One concern I have is I know that SharePoint server does not enforce referential integrity or relationships among lists so what is the best workaround to ensure that if a primary key attribute is changed in one list that also acts as a foreign key in another
list is sharepoints equivalent to maintaining referential integrity?

All replies

In SP2007 integration with access you are limited to linking the tables to lists or exporting them to lists altogether. Most folks link as this allows you to update in either location. However, in SP2010 you can create Web Enabled Access Databases that live
in SharePoint which is a huge step forward ...

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.