SharePoint Document Issues

Use a Microsoft Access Front End with SharePoint-Linked Tables

Anum MushtaqAnum Mushtaq Nov 20, 2026 869 views

Question details

Build an Access front end with local forms and VBA that uses data stored in SharePoint lists.

Use a Microsoft Access Front End with SharePoint-Linked Tables
Product
Microsoft Access and SharePoint
Device & OS
not provided
Scenario
An Access form needs to read and add records to a SharePoint list without storing the application data in a local table.
Observed behavior
The linked SharePoint list appears as a table object in Access, and deleting that link removes the form's record source.
Before you start

Confirm that you can access the SharePoint site and have permission to read or edit the target list. Identify the list and the Access form that will use it.

Solution 1Recommended

Link the SharePoint list and use it as the form's record source

Use a linked table to connect an Access form to data that remains in SharePoint.

The linked table is an Access object that points to the SharePoint list; its presence does not mean the list data has been moved into a local Access table. Keep the link if the form depends on it.

An Access SQL INSERT statement cannot use a SharePoint URL in place of a table name. A custom VBA integration using SharePoint APIs is a different approach and requires additional authentication and code.

1
Link the list

In Access, open External Data and choose New Data Source > From Online Services > SharePoint List. Enter the SharePoint site address, choose the option to link to the data source, and select the list. Menu names may vary by Access version.

2
Set the record source

Open the form in Design View, open its Property Sheet, and set Record Source to the linked SharePoint table or a query based on it.

3
Test the form

Switch to Form View and open or add a record. Check the SharePoint list to confirm that permitted changes appear there.

Link the SharePoint list and use it as the form's record source
Keep the linked table: Deleting the linked table breaks forms and queries that use it. Hide the object instead if the goal is to reduce its visibility in Access.
Free Microsoft Office alternative

Work with Office files in WPS Office

WPS Office is a free, lightweight alternative for everyday document and spreadsheet work, with a familiar interface and Office file compatibility for easier migration. It does not replace Access forms, VBA, or SharePoint-linked tables.

Open and edit spreadsheet data in a familiar interface.Compatible with common Microsoft Office formats, including XLSX and DOCX.Use a free, lightweight suite for everyday office tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Does a linked SharePoint list store the application data in an Access table?

The linked table is an Access object that points to the SharePoint list; the list remains the data source. Access may cache data locally, depending on its configuration and use.

Can I delete the linked table and keep the form working?

Not if the form's Record Source depends on that table. Keep the link or change the form to use another valid record source.

Can I use a SharePoint URL as the table name in an Access INSERT statement?

No. Access SQL needs a valid table or query name. Use the linked table in the statement, or build a separate integration using SharePoint APIs.

Does hiding the Navigation Pane secure the SharePoint data?

No. Hiding the pane only limits visibility in the Access interface. Configure SharePoint site or list permissions to control who can access and change the data.