Error when trying to export a SharePoint list to Ms-Access Table
When I tried to export a SharePoint list to Access table:
I got the below error message.
“You do not have the necessary permissions to use the ‘
This is because: List contains a column name that has more than 64 characters. Access 2007 database engine disallows columns that have names that contain more than 64 characters.
Solution:
Use only column names that contain less than 64 characters in SharePoint lists.
KB Article addressing this issue: https://support.microsoft.com/kb/924739