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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for