Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 924739 - Last Review: December 4, 2007 - Revision: 3.2
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"
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 '<ListName>' object. Have your system administrator or the person who created this object establish the appropriate permissions for you.
The term "column name" is what you see in the SharePoint user interface. Colum name is the column’s display name.
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
- In a Windows SharePoint Services 3.0 Web site, click Lists in the View All Site Content pane.
- Click Create, and then click Custom List in the Custom Lists column.
- In the Name box, type TestList, and then click Create.
- Click Settings, and then click Create Column.
- In the Column name box, type NewColumnWithColumnHeaderLengthOfMoreThan64Characters1111111111111111111111, and then click OK.
- Click New, type FirstValue in the Title box, type TestValue in the NewColumnWithColumnHeaderLengthOfMoreThan64Characters1111111111111111111111 box, and then click OK.
- Start Access 2007.
- Click Blank Database in the New Blank Database section, and then click Create.
- Click the Create tab, click SharePoint Lists, and then click Existing SharePoint List.
- In the Site Address list, select the Windows SharePoint Services Web site in which you created the TestList list, and then click Next.
- Click to select the check box for the TestList list, and then click OK.
APPLIES TO
- Microsoft Office Access 2007
- Microsoft Office SharePoint Server 2007
- Microsoft Windows SharePoint Services 3.0
| kberrmsg kbtshoot kbbug kbprb kbexpertiseinter KB924739 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
|
acai berry cleanse scam oprah
- http://acaiberrymaxx.org/acai-berry-cleanse-scam-oprah
|
Report As Irrelevant
|
| Written:
5/13/2010 6:03 AM |
|
|