Sunday, January 16, 2011

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



You might also like:
SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Document SharePoint Farm
Automatically generate SharePoint documentation.
*Sponsored


Check out these SharePoint products:

No comments :

Post a Comment

Please Login and comment to get your questions answered!

You might also like:

Related Posts Plugin for WordPress, Blogger...