Article ID: 924739 - View products that this article applies to.
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:
Note The term "column name" is what you see in the SharePoint user interface. Colum name is the column’s display name.
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.
This problem occurs because the Access 2007 database engine disallows columns that have names that contain more than 64 characters.
To work around this problem, use only column names that contain less than 64 characters in Windows SharePoint Services lists.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Steps to reproduce the problem