SharePoint Document Issues

How to Link an Access Front End to a SharePoint Backend

Algirdas JasaitisAlgirdas Jasaitis Nov 3, 2026 868 views

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.

How to Link an Access Front End to a SharePoint Backend
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the ACCDB File

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.

2
Delete Old Linked Tables

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.

3
Initiate SharePoint Linking

Navigate to the 'External Data' tab on the ribbon. Click on 'New Data Source', select 'From Online Services', and then choose 'SharePoint List'.

4
Link to the Data Source

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.

5
Test and Distribute

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.

Remove Old Links and Connect to SharePoint Lists
Concurrent Remote Access Enabled: By giving each user a separate front-end copy on their local workstation, multiple users can now securely share and edit the same SharePoint data concurrently from anywhere with an internet connection.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free installer tailored for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the brief on-screen instructions to install the suite on your device.
  3. 3. Start Creating: Launch WPS Office to instantly open your existing Office files or create new documents with perfect formatting.
Fully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx).Free and lightweight office suite with a familiar, easy-to-use tabbed interface.Built-in PDF editing and conversion tools to streamline your workflow.Seamless cloud integration for easy document sharing and collaboration.
microsoft office alternative - wps office

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.