Office Compatibility Issues

Link Microsoft Access 365 Tables to SharePoint Lists

Aamir Naveed AkramAamir Naveed Akram Nov 20, 2026 869 views

Question details

The user wants to use SharePoint lists as linked tables for a Microsoft Access 365 desktop front end.

Link Microsoft Access 365 Tables to SharePoint Lists
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.
Before you start

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.

Solution 1Recommended

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.

1
Prepare the lists

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.

2
Open the Access database

In Microsoft Access, open the desktop database that will serve as the front end.

3
Start the link wizard

Select External Data > New Data Source > From Online Services > SharePoint List. Menu wording may vary by Access version.

4
Connect to the site

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.

5
Select and test the lists

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.

6
Distribute the front end

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.

Link SharePoint lists to the Access desktop database
Access Web Apps are separate: Access Web Apps are no longer supported. Power Apps is an option for a web or mobile solution, but it is not required for this desktop linked-table setup.
Free Microsoft Office alternative

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.

Work with tabular data in WPS SpreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar interface for documents, spreadsheets, and presentationsMove compatible Office files into a free, lightweight productivity suite
microsoft office alternative - wps office

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.