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 - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

Leave a Reply

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