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
Hey there! I've been following your site for some time now and finally
ReplyDeletegot the bravery to go ahead and give you a shout out from Porter Texas!
Just wanted to mention keep up the excellent work!
Stop by my web blog chicago computer services ()
Well done Gugs !!! It helped me :) --- Iqbal Sayed
ReplyDeleteNice answer back in return of this difficulty with
ReplyDeletefirm arguments and explaining everything about
that.
My web blog; homepage ()
Thanks for ones marvelous posting! I seriously enjoyed reading it,
ReplyDeleteyou might be a great author. I will remember to bookmark your blog and will
often come back sometime soon. I want to encourage you to ultimately continue your great
posts, have a nice morning!
my web page ... web site ()
Thanks for the auspicious writeup. It in reality was a leisure account it.
ReplyDeleteGlance complex to more introduced agreeable from you! However, how can
we communicate?
my weblog homepage; ,
Hello there! This is my first visit to your blog! We are a
ReplyDeletegroup of volunteers and starting a new initiative in a community
in the same niche. Your blog provided us valuable information to work on.
You have done a marvellous job!
Here is my site - semper gestion ()
Thanks!
DeleteI pay a visit each day some blogs and blogs to read articles or reviews,
ReplyDeletehowever this weblog offers feature based writing.
Feel free to visit my website; semper gestion (sempergestion.net)
My plasure :), Thank you!
Delete