How to Link an Access Front End to a SharePoint Backend
Question details
The user needs to connect a local Access database front end to backend tables hosted on SharePoint without generating duplicate tables or retaining broken local links.

- Product
- Microsoft Access and SharePoint
- Device & OS
- not provided
- Scenario
- Splitting an Access database to distribute the front end to remote users while hosting the backend tables on SharePoint for concurrent access.
- Observed behavior
- The database front end retains broken links to the old local backend, and attempting to link the new SharePoint lists directly creates duplicate tables instead of updating the existing connections.
Ensure you are working with the original, uncompiled ACCDB front-end file rather than the compiled ACCDE version, and verify you have proper permissions to the SharePoint site.
Remove Old Links and Connect to SharePoint Lists
Delete existing broken connections to the old local backend before establishing fresh links to the new SharePoint lists to prevent duplicate tables.
When migrating a backend to SharePoint, Access will not automatically overwrite old local table links. You must manually clear the broken links first, otherwise, Access will append numbers to the new SharePoint links, resulting in duplicate tables.
Always perform these structural changes in the ACCDB file before compiling it for your end users.
Launch Microsoft Access and open your front-end database using the original .accdb file format. Do not use the .accde file for modifying table links.
In the Navigation Pane, locate the linked tables pointing to your old backend. Right-click each one and select 'Delete' to remove the broken links from the front end.
Navigate to the 'External Data' tab on the ribbon. Click on 'New Data Source', select 'From Online Services', and then choose 'SharePoint List'.
In the dialog box, enter the URL of your SharePoint site. Crucially, choose the option to 'Link to the data source by creating a linked table' rather than importing the data, then select the required lists to link.
Test the database functionality to ensure all forms and reports pull data correctly from SharePoint. Once verified, save the file, compile it into an ACCDE file, and distribute a separate copy to each user.

Looking for a Lightweight Alternative for Daily Office Tasks?
While complex database management requires Microsoft Access, WPS Office offers a free, lightweight, and highly compatible alternative for your standard document, spreadsheet, and presentation needs. Experience seamless format compatibility without the heavy subscription costs.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer tailored for your operating system.
- 2. Install WPS Office: Run the setup file and follow the brief on-screen instructions to install the suite on your device.
- 3. Start Creating: Launch WPS Office to instantly open your existing Office files or create new documents with perfect formatting.

Frequently Asked Questions
Why am I getting duplicate tables when linking to SharePoint?
Duplicate tables occur if you link the new SharePoint lists without first deleting the old linked tables pointing to your previous local backend. Always delete the broken links in the Navigation Pane before establishing the new SharePoint connection.
Can I link to a SharePoint backend using an ACCDE file?
No, you cannot modify table designs or links in a compiled database. You must perform the linking process using the uncompiled ACCDB front-end file. Once the links are successfully established and tested, you can compile the database into a new ACCDE file for users.
Can multiple remote users access the SharePoint backend at the same time?
Yes, Access databases split with a SharePoint backend are designed for this. By distributing separate, individual copies of the front end to each user's computer, multiple people can securely access and update the shared SharePoint data concurrently.




