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.
Use only column names that contain less than 64 characters in SharePoint lists.
KB Article addressing this issue: https://support.microsoft.com/kb/924739