SharePoint Document Issues

Fix SharePoint Error: Cannot Save Property in Access

Jason MillerJason Miller Oct 29, 2026 869 views

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.

How to Fix SharePoint Error: Cannot Save Property; Property Is a Schema Property
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 you start

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.

Solution 1Recommended

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.

1
Create a New List

In SharePoint, create a new list with the exact same fields and data types as the problematic list.

2
Append Existing Data

Use an Append Query in Microsoft Access to transfer the existing data from the old linked table into the newly created list.

3
Verify Data Transfer

Check that all records, specifically the contract end dates and other date fields, transferred successfully without triggering schema errors.

4
Replace Old List

Once the migration is confirmed successful, delete the old corrupted SharePoint list and rename the new list to match the original name.

Recreate the Corrupted SharePoint List
Identify Invalid Data: If the migration fails during the append process, examine the source records to identify fields containing invalid data or formatting issues that might be blocking the transfer.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to complete the setup process.
  3. 3. Open Your Files: Launch WPS Office to instantly view and edit your existing Word, Excel, and PowerPoint documents with full format compatibility.
Highly compatible with Microsoft Word, Excel, and PowerPoint formatsLightweight application that runs smoothly on almost all devicesFeature-rich Spreadsheet tool for advanced data logging and analysisFamiliar user interface for a seamless transition
QA img-9

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.