Access linked table to a SharePoint list returns #Deleted

Symptom

When you open a linked table in Access that's linked to a SharePoint list, the results are displayed as #Deleted.

This issue occurs if the following conditions are true:

• The Access database uses the following caching options under Access > Options > Current Database:
  • Use the cache format that is compatible with Microsoft Access 2010 and later is selected.
  • Never Cache is cleared.
• The linked table contains one or more Memo fields.

Workaround

To work around this issue, use one of the following methods:

• Change the caching options to one of the following:
  • Clear the option Use the cache format that is compatible with Microsoft Access 2010 and later.
  • Select both the Use the cache format that is compatible with Microsoft Access 2010 and later and Never Cache options.
• Use the ImportSharePointList macro action to link to a SharePoint view of the list that doesn't contain the Memo fields.