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 ‘{GUID}’ object. Have your system administrator or the person who created this object establish the appropriate permissions for you”.

"You do not have the necessary permissions to use the '{GUID}' object. Have your system administrator or the person who created this object establish the appropriate permissions for you".

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

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

Leave a Reply

Your email address will not be published. Required fields are marked *