CODEWITHSUNDEEP
sharepoint-2013ms-access-2013
Darryl
Darryl

Reputation: 53

Access Web App Link To SharePoint User List

I'm trying to build a 2013 Access web application that uses the SharePoint 2013 user list as a lookup. The SharePoint user list doesn't show up when linking to the SharePoint sites lists through add table and it doesn't work to link to /_catalogs/users/. This is relatively simple to do with SharePoint lists but I haven't been able to find any way to do it within an Access web application table.

Upvotes: 1

Views: 766

Answers (1)

Julian Knight
Julian Knight

Reputation: 4923

You cannot link a web Database to a SharePoint list.

This is because the data in a web database is actually kept as a special SQL Server database in Azure. It is an entirely separate infrastructure.

You will need to create two databases if you want to do everything in Access. One for the web data and one to pull everything together.

Upvotes: 1

Related Questions