14 August, 2012

Error message when you try to add an existing Windows SharePoint Services 3.0 list to an Access 2007 database: "You do not have the necessary permissi

Symptoms:
You try to add an existing Microsoft Windows SharePoint Services 3.0 list to a Microsoft Office Access 2007 database. When the Windows SharePoint Services list contains a column name that has more than 64 characters, you receive an error message that resembles the following:

You do not have the necessary permissions to use the '' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.Note The term "column name" is what you see in the SharePoint user interface. Colum name is the column’s display name.


Cause:
This problem occurs because the Access 2007 database engine disallows columns that have names that contain more than 64 characters.

MS KB Article:

No comments:

Post a Comment

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