Use a Microsoft Access Front End with SharePoint-Linked Tables
Question details
Build an Access front end with local forms and VBA that uses data stored in SharePoint lists.

- 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.
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.
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.
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.
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.
Switch to Form View and open or add a record. Check the SharePoint list to confirm that permitted changes appear there.

Limit visibility of linked tables in the Access front end
Hide database objects from the interface while retaining the links required by forms and queries.
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.

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.




