Fix SharePoint Error: Cannot Save Property in Access
Question details
The user encounters a schema property error in a Microsoft Access database linked to SharePoint lists when attempting to save specific field changes, such as a contract end date.

- Product
- Microsoft Access / SharePoint
- Device & OS
- not provided
- Scenario
- A user is trying to add or update a date field in a new record within an Access database linked to a SharePoint list.
- Observed behavior
- The system displays the error 'Cannot save property; property is a schema property' or 'Couldn't save the object', although the records may still be saved and visible to other users.
Before attempting to migrate or recreate your SharePoint lists, ensure you have a backup of your Access database and the necessary administrative permissions to modify list structures in SharePoint.
Recreate the Corrupted SharePoint List
Since the list or its schema connection might be corrupted, recreating the list and appending the existing data often resolves property saving errors.
This method rebuilds the underlying schema in SharePoint, ensuring that Access does not struggle with corrupted or locked field properties when saving new records.
In SharePoint, create a new list with the exact same fields and data types as the problematic list.
Use an Append Query in Microsoft Access to transfer the existing data from the old linked table into the newly created list.
Check that all records, specifically the contract end dates and other date fields, transferred successfully without triggering schema errors.
Once the migration is confirmed successful, delete the old corrupted SharePoint list and rename the new list to match the original name.

Isolate the Connection Issue
Verify whether the issue originates from Access attempting to improperly modify SharePoint list structures or if it's a direct SharePoint issue.
Looking for a Lightweight Office Suite?
While WPS Office does not feature a direct relational database alternative to Microsoft Access, it provides a highly efficient, free, and lightweight solution for all your document, spreadsheet, and presentation needs. Experience seamless compatibility with Microsoft Office file formats.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to complete the setup process.
- 3. Open Your Files: Launch WPS Office to instantly view and edit your existing Word, Excel, and PowerPoint documents with full format compatibility.

Frequently Asked Questions
Why do I get a schema property error when pasting dates in Microsoft Access?
This typically occurs when there is a mismatch between the data format being pasted in Access and the schema constraints defined in the linked SharePoint list, or if the backend SharePoint list connection has become corrupted.
Can I just refresh the SharePoint link in Access to fix the issue?
Refreshing the link via the Linked Table Manager can sometimes restore connection stability. However, if the underlying SharePoint list schema is corrupted, refreshing might trigger secondary errors like 'Couldn't save the object', meaning the list will likely need to be recreated.
Does WPS Office have a database program similar to Microsoft Access?
Currently, WPS Office focuses on core productivity tools including Writer (documents), Spreadsheet (Excel alternative), and Presentation. It does not include a direct relational database management system like Microsoft Access.




