Issue: Connecting a List
to Access database throws an error message.
You do not have the necessary permissions to use the '' object. Have
your system administrator or the person who created this object establishes the
appropriate permissions for you.
Background: One of my clients
trying to connect a SharePoint List by MS Access. After waiting some time,
getting error message specified above. Also getting the same error message when
trying to connect to MS Access from SharePoint by converting the list to data
sheet view
System Information:
1) Windows XP
2) Office 2007
3) Access 2007
4) Access 2010
5) SharePoint 2007
Troubleshooting:
1) Tried
to save list as a template and created a new list issue persist in both cases
when saved with content and without content.
2) Tried
to connect same list to excel and did not work.
3) Tried
repairing the office suit, didn’t work at all.
4) This
seems to be clearly an issue with the SharePoint List.
Resolution:
Tried
looking at columns side of the list and did some deep dive based of the exact
error were getting and found the below KB from MS, which was the resolution of
the problem and gave a clear instructions to reproduce the issue.
Checked
the columns names on the List and there were two columns which were using more
than 64 characters in it title field.
Eliminating
them from the list and connecting List again from MS Access to SharePoint does
work and vice versa.
Applies to:
1) Windows SharePoint
Service 3.0
2) MOSS 2007, MS
Access 2007
3) MS Access 2010.
If
you have any queries/questions regarding the 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.
