Fix a Linked SharePoint List Read-Only Issue in Microsoft Access
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.

- 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.
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.
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.
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.
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.
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.
Save the changes to the table design, switch back to Datasheet View, and attempt to edit a record or add a new row.

Inspect Complex Column Types and Data Conflicts
Identify and temporarily remove complex column types in SharePoint that Microsoft Access cannot process for write operations.
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. Download WPS Office: Visit the official WPS Office website and download the free installation package for your PC or Mac.
- 2. Install the Software: Run the setup file and follow the simple on-screen instructions to install the suite.
- 3. Open Your Office Files: Launch WPS Office and seamlessly open your existing Word, Excel, and PowerPoint documents with zero formatting loss.

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.




