Permission & Access Issues

Fix SharePoint List Items Locked or Read-Only in Microsoft Access

Camila MilosovichCamila Milosovich Nov 13, 2026 868 views

Question details

Resolve SharePoint list items that become locked or read-only when the list is linked to Microsoft Access, especially in SharePoint Server with multiple editors.

Fix SharePoint List Items Locked or Read-Only in Microsoft Access
Product
Microsoft Access and SharePoint Server
Device & OS
not provided
Scenario
Multiple users edit a SharePoint list through linked Access tables, and individual list items become read-only or locked.
Observed behavior
Some items cannot be edited in SharePoint or Access forms, update queries return lock violations, and items can only be edited directly in a linked Access table.
Before you start

Confirm whether the environment is SharePoint Online or SharePoint Server, and make sure you have permission to change the Access database options before applying cache or lock settings.

Solution 1Recommended

Clear the Access 2010-compatible web service cache format

Use this solution first when some SharePoint list items are read-only and update queries report lock violations.

Access caching can retain an older web service cache format that conflicts with SharePoint Server linked lists and creates record lock problems. Clearing this option forces Access to use the current cache format for the database.

1
Open Access database options

In Microsoft Access, click File > Options > Current Database.

2
Locate Caching Web Service

Scroll to the Caching Web Service section and find the option "Use the cache format that is compatible with Microsoft Access 2010".

3
Clear the cache compatibility option

Clear the checkbox, click OK, then close and reopen the Access database.

4
Retry editing the list item

Attempt to edit the previously locked SharePoint list item through the Access form or SharePoint UI to confirm the lock violation is resolved.

Clear the Access 2010-compatible web service cache format
Cache setting cleared: After clearing this option, avoid enabling it again unless required for an older Access 2010-compatible workflow.
Free Microsoft Office alternative

Use WPS Office as a Free Alternative When Access and SharePoint Lock Issues Interrupt Your Work

WPS Office is a free, lightweight office suite with a familiar ribbon interface and strong compatibility with Microsoft Office file formats. While it does not replace Microsoft Access databases, it makes daily document, spreadsheet, and presentation work easier when Access-SharePoint lock problems block your Microsoft Office workflow.

Avoid Access-specific SharePoint list lock issues for regular document and spreadsheet editingOpens, edits, and saves Microsoft Excel, Word, and PowerPoint formats including .xlsx, .docx, and .pptxFree and lightweight with a familiar ribbon UI for a short learning curveSeamless migration from Microsoft Office for daily tasks without an Access database dependency
microsoft office alternative - wps office

Frequently Asked Questions

Why do some SharePoint list items become read-only when linked to Microsoft Access?

The most common cause is an incompatible web service cache format in Access, but record-level locking, check-out status, and concurrent edits can also lock individual SharePoint list items.

Where do I clear the Access 2010-compatible cache format?

In Microsoft Access, go to File > Options > Current Database > Caching Web Service and clear the option "Use the cache format that is compatible with Microsoft Access 2010".

What does the lock violation error mean when running an Access update query?

It usually means another user or process holds a conflicting lock on the SharePoint list item, or the Access cache is using an older compatible format that conflicts with SharePoint Server linked lists.

Does WPS Office include Microsoft Access or SharePoint linked table support?

No, WPS Office does not include Microsoft Access. It is a free alternative for documents, spreadsheets, presentations, and PDF files with strong Microsoft Office format compatibility.

Can I use WPS Office to edit a SharePoint list directly?

WPS Office is not designed to edit SharePoint linked Access tables. For daily Microsoft Office-compatible file work, however, it can open and save .xlsx, .docx, and .pptx files.