You do not have the necessary permissions to use the '' object" + SharePoint2007 + Access

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.

http://support.microsoft.com/kb/924739

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.