SharePoint Document Issues

Fix a Linked SharePoint List Read-Only Issue in Microsoft Access

Adam DavisAdam Davis Nov 2, 2026 870 views

Question details

A user is unable to edit a specific SharePoint list linked to Microsoft Access because it is read-only, despite having site-owner permissions and a defined primary key. Other linked lists work perfectly, and an empty copy of the problematic list allows editing.

Why Is a Linked SharePoint List Read-Only in Access?
Product
Microsoft Access and SharePoint
Device & OS
not provided
Scenario
Attempting to edit data within a SharePoint list that is linked as a table in Microsoft Access.
Observed behavior
The linked list restricts any data modification, functioning strictly in read-only mode, particularly after being populated with data.
Before you start

Ensure you have your Microsoft Access database closed initially and your SharePoint site open in a web browser to quickly verify list settings and user permissions.

Solution 1Recommended

Verify Permissions and Define Primary Key in Design View

Ensure that Access correctly recognizes the primary key from SharePoint to allow write operations, and confirm that permissions are correctly applied to the populated list.

Microsoft Access requires a uniquely identifiable field (a primary key) to update or edit records in a linked table. Even if the SharePoint list has an ID field, Access may sometimes fail to automatically map it as the primary key during the linking process.

1
Confirm SharePoint Permissions

Navigate to the problematic SharePoint list in your browser, go to List Settings, and verify under 'Permissions for this list' that your account actively holds Read and Write (or Full Control) access, rather than just inheriting read-only group permissions.

2
Open Access Design View

Launch Microsoft Access, right-click the read-only linked SharePoint table in the Navigation Pane, and select 'Design View'. If a warning prompts about changing a linked table, accept it.

3
Set the Primary Key

Locate the 'ID' field (which corresponds to the SharePoint ID). Select the row, and click the 'Primary Key' icon on the Table Design ribbon tab to assign it.

4
Save and Test

Save the changes to the table design, switch back to Datasheet View, and attempt to edit a record or add a new row.

Verify Permissions and Define Primary Key in Design View
Primary Key Assignment: Manually forcing the Primary Key designation in Access often instantly resolves read-only locks on linked SharePoint data.
Free Microsoft Office alternative

Looking for a Lightweight Office Suite? Try WPS Office

While Microsoft Access is a specialized database tool, for your daily documents, spreadsheets, and presentations, WPS Office serves as an excellent, free alternative. Enjoy high compatibility with Microsoft Word, Excel, and PowerPoint files without the costly subscription.

  1. 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your PC or Mac.
  2. 2. Install the Software: Run the setup file and follow the simple on-screen instructions to install the suite.
  3. 3. Open Your Office Files: Launch WPS Office and seamlessly open your existing Word, Excel, and PowerPoint documents with zero formatting loss.
Fully compatible with Microsoft Office formats (DOCX, XLSX, PPTX)Free and lightweight alternative for everyday productivityFamiliar, easy-to-use tabbed interface for seamless transitionBuilt-in robust PDF editor, converter, and reader
microsoft office alternative - wps office

Frequently Asked Questions

Can a calculated column in SharePoint make the Access table read-only?

Yes, depending on the complexity of the calculation and the data types involved, Access may struggle to interpret the schema, which can force the entire linked table into a read-only state.

Why does a copied SharePoint list work without data, but becomes read-only with data?

This usually happens when the structural schema is fine, but specific records within the populated list contain formatting, corrupted entries, or complex multi-value data that triggers a read-only lock when Access attempts to parse it.

Do I need special permissions in Access to edit linked SharePoint lists?

Access itself does not govern the permissions; it relies on your SharePoint permissions. You must have Read and Write (or Edit) permissions natively on the SharePoint site and the specific list to make changes via Microsoft Access.