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 regarding the mentioned information then please let me know.
I would be more than HAPPY 2 HELP you as well as RESOLVES your issues, thank you
