Link Microsoft Access 365 Tables to SharePoint Lists
Question details
The user wants to use SharePoint lists as linked tables for a Microsoft Access 365 desktop front end.

- Product
- Microsoft Access 365 and SharePoint Lists
- Device & OS
- not provided
- Scenario
- Staff use an Access desktop database on their computers while shared data is stored in SharePoint lists.
- Observed behavior
- The desired setup is a desktop Access front end connected to SharePoint lists, not a discontinued Access Web App.
Confirm that staff can sign in to the SharePoint site and have the permissions needed to read or edit the lists. Have the SharePoint site URL and the Access desktop database ready.
Link SharePoint lists to the Access desktop database
Use this approach to keep shared list data in SharePoint while staff work through an Access desktop front end.
Linked tables connect the Access database to existing SharePoint lists; they are not Access Web Apps. Staff need appropriate SharePoint permissions and an Access desktop environment to use the front end.
Open the SharePoint site, select New > List, and create any lists you need. Use the site's permissions settings to grant staff the required access.
In Microsoft Access, open the desktop database that will serve as the front end.
Select External Data > New Data Source > From Online Services > SharePoint List. Menu wording may vary by Access version.
Enter the SharePoint site URL, choose the option to link to the data source by creating a linked table, and select Next. Sign in if prompted.
Select the lists to link and finish the wizard. Open each linked table from the Navigation Pane, then test reading and editing with a staff account that has the intended permissions.
Provide the Access front-end database to staff and have each user open it and sign in to SharePoint if prompted. Test the forms and queries against the linked tables.

Use WPS Office for compatible documents and spreadsheets
WPS Office is a free, lightweight alternative for everyday Office documents, with a familiar interface and compatibility that helps users move existing files. It does not replace Microsoft Access or create Access linked tables to SharePoint lists.

Frequently Asked Questions
Do I need Power Apps to use SharePoint lists with Access?
No. In the Access desktop database, use External Data > New Data Source > From Online Services > SharePoint List to create linked tables. Power Apps is an option if you need a web or mobile solution.
What URL should I enter when linking a SharePoint list?
Enter the URL of the SharePoint site that contains the list in the SharePoint List link wizard, then select the lists you want to link.
Can staff edit linked SharePoint data from Access?
They can edit supported data through the linked tables or Access forms when their SharePoint permissions allow it. Test the workflow using a staff account before distribution.
Is a linked Access desktop database the same as an Access Web App?
No. A desktop database runs in Access and can link to SharePoint lists. Access Web Apps were a separate, discontinued service.




