19 October, 2011

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

Team-today I worked on one issue and would like to share the resolution details with all of you so that we can efficiently resolve any forthcoming issues based on the same type.

Problem description:
When You try to add an existing sharepoint list to a Microsoft Office Access 2007 database then you receive an error message that resembles the following:

Error message: 
You do not have the necessary permissions to use the '<ListName>' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.

Action Taken:
1) Checked the number of groups which are present on the site and user permissions on the site as well as for the specific list that we trying to connect
2) User has Full control on the site as well as for the list also so problem is not from sharepoint end
3) Checked the office application installed on the system and found multiple version which consist of office 2003 as well as office 2007
4) Checked the access version and found out it belongs to Office 2007 suite
5) Checked on my machine to reproduced the same and we are able to reproduced it so the problem is not from the Office suite
6) User conveyed that its working on one of the sharepoint site and compare both the sites and found out some differences in terms of columns and characters but to make sure did research and found the Microsoft KB: http://support.microsoft.com/kb/924739

Microsoft KB states that it’s a known issue. Details as follows:
Cause: This problem occurs because the Access 2007 database engine disallows columns that have names that contain more than 64 characters.

Workaround: To work around this problem, use only column names that contain less than 64 characters in SharePoint lists.

Resolution for this issue: there was one column which has more than 64 characters, we shorten the column name and tried connecting the list to access and it works without any issues.

If you have any queries|questions|doubts regarding above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, thank you J

2 comments:

  1. I got this same error and none of my column names were over 64 characters. Any other ideas?

    ReplyDelete
  2. are you able to add any other list apart from the current one where you are facing the issue?

    I wanted to isolate the issue as it belongs to specific list or across all list's

    Please let me know your results, thank you

    ReplyDelete

Your feedback is always appreciated. I will try to reply to your queries as soon as possible- Amol Ghuge

Note: Only a member of this blog may post a comment.