Error when trying to export a SharePoint list to Ms-Access Table

When I tried to export a SharePoint list to Access table: access

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: http://support.microsoft.com/kb/924739

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

Leave a Reply