Access crashes when you update a linked SharePoint list

Symptoms

When you update a linked SharePoint list in Microsoft Access, and then you try to commit the record change, Access crashes.

Cause

This problem occurs because of an infinite loop condition that occurs when Access tries to validate a lookup column’s bound value, and the physical order of the bound value is not also in logical order. This problem occurs if the Use the cache format that is compatible with Microsoft Access 2010 and later check box is not selected.

Caching Web Service and SharePoint tables

Workaround

To work around this problem, select the Use the cache format that is compatible with Microsoft Access 2010 and later check box. To do this, follow these steps:

  • In Access, select File > Options.
  • Select Current Database.
  • Scroll down to the Caching Web Service area, and then locate the Microsoft SharePoint tables.
  • Make sure that the Use the cache format that is compatible with Microsoft Access 2010 and later check box is selected.

More Information

For more information about known issues that occur when you use SharePoint lists in Access, see Access cache formats for SharePoint lists/document libraries.
Properties

Article ID: 3200416 - Last Review: Oct 26, 2016 - Revision: 1

Feedback