How do I link an Access database to a SharePoint list?

Question

A linked SharePoint list or Access database updates both ways. On the External Data tab, select More > SharePoint List. Specify the SharePoint site. Select Link to the data source by creating a linked table, and then click Next. Select the list you want to link to, and then click OK.

Can you add Access database to SharePoint?

Access 2010 and Access Services provide a platform for you to create databases that you can use on a SharePoint site. You design and publish a web database by using Access 2010 and Access Services, and people who have accounts on the SharePoint site use the web database in a web browser.

Can Access database be shared on SharePoint?

There are several ways to share Access data on a SharePoint site: Linking The linking process connects to data in another program, so that you can view and edit the latest data both in SharePoint and in Access without creating and maintaining a copy of the data in Access.

On the permissions page for the list, on the Edit tab, click Grant Permissions. Type the name of the group or the individual you want to grant access to in the Users/Groups box. Choose the level of permissions you want the group or individuals to have. Click OK.

Expert · Answer