Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Access crashes when you update a linked SharePoint list


View products that this article applies to.

Symptoms

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

↑ Back to the top


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

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 3200416
Revision : 1
Created on : 1/7/2017
Published on : 10/26/2016
Exists online : False
Views : 48