Fix SharePoint List Items Locked or Read-Only in Microsoft Access
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.

- 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.
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.
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.
In Microsoft Access, click File > Options > Current Database.
Scroll to the Caching Web Service section and find the option "Use the cache format that is compatible with Microsoft Access 2010".
Clear the checkbox, click OK, then close and reopen the Access database.
Attempt to edit the previously locked SharePoint list item through the Access form or SharePoint UI to confirm the lock violation is resolved.

Check record-level locking and concurrent edit conflicts
Use this solution if items remain locked after clearing the cache format, especially when multiple users work with the same linked SharePoint list.
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.

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.




