.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SharePoint 'Open with Access' - > 'Link to data on the SharePoint site' does not display data wi

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :SharePoint

Here's the scenario:

- I have a custom list in SharePoint 2010 with approximately 30 columns and 450 rows

- When I got to 'List Tools' -> 'List' -> 'Open With Access', I have two options 1) Link to data on the SharePoint Site and 2) Export a copy of the data

- If I select either option, I am able to view the items in my list in 'DataSheet' view and in the bottom right of Access I see the 'Online with SharePoint' text

- If I select the PivotTable view and drag in a column to either the row or column option, I have not seeing my data if I choose option #1 above (Link to data on the SharePoint Site).  I am able to see my values if I select option #2 above and view in PivotTable view

- If I click the 'Refresh Pivot' button in the ribbon still no data. 

- If I got back to datasheet view, I see my data

Any ideas?

Any suggestions

View Complete Post

More Related Resource Links

Cannot access SharePoint 2007 site after moving data to another AD domain



We are setting up a staging farm on a test domain. For this we took a copy of the data from production and attached them to staging. In the test domain I created user with same user name as in production but they cannot login. I tried making the user site admin still he cannot access. I hope there is a problem when we move sharepoint data between domains.

I ran the stsadm migrateuser comman with ignoresidhistory and it ran successfully, but still user get access denied message. Is there someway this can be fixed?

For example, we have 2 domains, prod and test. I setup SharePoint farm (same patch level as prod) in domain test and copied all my content databases and attached in test domain sharepoint. The system account in test domain is “test\spadmin”. Now only he can access the new site in test domain.

There was a user “user1” in prod domain and I created a similar user in test domain - “test\user1”. Even after giving him full control on the sites, he gets Access Denied error. I tried creating a new user in test domain that does not exist in prod domain, even he cannot access the site because of Access Denied exception. Is it a limitation of SharePoint that we cannot move data between domains.

PS: We are running MOSS 2007 Ent 64 bit SP1 and SQL Server 2005 SP3. We use NTLM authentication.


How to open More then one lists of sharepoint 2010 as a tables in access 2010 data base


Hi  friends  this is siddiq ,

                                   How can i open sharepoint 2010 lists in access 2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate  database.But i want to take  both the lists  in one access database 

Mohammad Siddiqali

SharePoint Portal Server 2001: Search and Access Disparate Data Repositories in Your Enterprise


The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.

Kayode Dada

MSDN Magazine April 2002

Sharepoint list group by column data ,display in webcontrol like panel or label


I  have a sharepoint list[Managers] with groupby sector column. like below




Each Sector group by column data i want to display in label or panel control.

How to do that ? how to write the logic?



Regards, Mansoor

Quick Note: Create Silverlight Applications to Access SharePoint 2010 Data

In this exercise, you will learn how to create Silverlight applications to display SharePoint 2010 lists inside DataGrid controls.

Developer Training: Data Access in Technologies in SharePoint 2010

Learn about the new data access technologies in SharePoint 2010 and how they can help increase your productivity. This training module covers the basics of LINQ handling and how to use the Client OM and REST to access SharePoint 2010 information remotely.

Quick Note (Scenario): Getting Started with Data Access in SharePoint 2010

The goal of these exercises is to give you the steps that you need to access data from various sources by using web development tools and technologies such as SharePoint 2010 and Visual Studio 2010.

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

Best way to display data of a single column from a Sharepoint Custom List

I'm trying to create pages that will automatically populate with data pulled from a sharepoint list (like title, department, contact info, etc.).   I'm using publishing pages. What would be the easiest way to do this, and how would I specify which data to pull from the list? For example, the page would be set up like this: [Title:biology] [Department:biology] [Contact Info:biology]   and when the page loads, it would look like this: Biology Lab Biology Department 123-456-7890   I want it to just pull the data -- I don't want a list view or anything like that.  I need this page to look pretty, and I need the each column's data to show up in a very specific place. How could I make pages that would do that?

workbooks inside of sharePoint site has data refresh error


We have workbooks inside of our SharePoint site, using NTLM authentication and Excel Services connectors. They correctly display graphs when the page is first opened, but all of them throw an error when users try to trigger an update. The error message sayss "Excel. An error occurred during an attempt to establish a connection to the external data source. The following connections failed to refresh: [name of any data cube in use]. Learn more about data refresh." We are not using Power Pivot (which may make it easier, but is not authorised for use by our server administrators yet).

display sharepoint list Data into content Query Web Part


Hi i have content query web part. now i want to show the sharepoint list data into my content query part

using CQWP setting, i am able to get only one column data but not all.

pls let me know how can i get all list data in different style format 

Using SharePoint web services to access KPI List data



How to get the indicators in a KPI list data(like list row data) from SharePoint using SharePoint web services





Custom Display in Data View column in SharePoint



I am using SharePoint designer 2007 to create Data View web part where I want custom display text in one column depending upon condition. In designer there is way to implement custom display which allows to change style conditionally. Is there any way to change the text conditionally?

Just to underline the problem I want to change text in Data View column conditionally.



Created a data view pages using sharepoint designer but can not display under browser



I created a data view page using the datasource I created connecting to our sql 2005 database.  I can see all data displyed in sharepoint designer 2007.

But once I preview it or run it from sharepoint site after saving it, I got this error.  Can anybody give me some clue or tips on how to fix it?

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator.

Thanks a lot



Sharepoint Designer 2007 not showing the updated site summary usage data


HI All,

I have sharepoint designer2007 in my production server.That Sharepoint designer is not showing the updated usage reports.It is showing only from 2008 Nov to 2009 Apr hits and downloads.But if i look in the site directly for the site usage reports site is showing updated reports properly.But Why not in the Sharepoint designer? And one more catch here is the same sharepoint designer displaying the updated usage reports for the sites which is running in other server.Can any one help on this issue please?

Thanks in advance Sreeni

Video: Access Data in SharePoint 2010 Web Parts by Using LINQ

Learn to create a SharePoint 2010 Web Part that retrieves data from lists by using LINQ.

Video: Create Silverlight Applications to Access SharePoint 2010 Data

Learn to create a Silverlight application that displays SharePoint 2010 lists inside DataGrid controls.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend