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 permissions to use the ‘<ListName>’ object”

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 ‘<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.

Here is a URL from Microsoft’s website which explains the above stated behaviour.

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

With the best SharePoint hosting price plans in the industry, Apps4Rent provides any sized business the power to integrate the virtual collaboration technology into their business model and streamline communications at a minimal SharePoint hosting price rate of $8.95 per month.

Related Links

Best SharePoint Hosting Price

Free SharePoint Hosting WSS 3.0 Templates

SharePoint Hosting Services

Hosted SharePoint Uses Benefits Features

Hosted Applications – SharePoint – Microsoft Exchange 2007

Hosted Exchange Mail Services