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

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

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.

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.

This demonstration illustrates how to work with list data and the Collaborative Application Markup Language (CAML). (Length: 5:05)

Our environment is SharePoint 2010 Enterprise, Windows Server 2008 R2 Standard and SQL server 2008 R2.   We have External lists that access a local database in SharePoint SQL Server. When new lists are added and permissions are given in the SharePoint Central Administration the domain users had to be in the Windows administration group to access the lists.   Recently in the same environment the domain users were removed from Windows Administration user group and could access the external lists.   In another similar test server we found adding the domain users to Windows Administration does not give the new domain users access to External lists.   The inconsistency is the issue. Has anyone seen this issue or provide a possible solution?

Hi,

I have seen numerous articles for the above, but they all just gloss over the step I am having a problem with, assuming nobody will have an issue with it. 

I'm trying to create an External Content Type so I can use it to display external data (from SQL Server) in an External List.  When I get to the step to add the connection and the SQL Server connection dialog box appears, I enter the server and database names and click OK with the Connect with User's Identity radio button still selected and I get the error message: login failed for user ''. The user is not associated with a trusted SQL Server connection.  I've tried to read up on the different purposes of the radio buttons on offer on this dialog box but don't know which I should really be using and don't think I can create a target application ID anyway in Foundation (for the other two radio button options) as that has to be done in the secure store services.  Can anybody help with this?

Hi

I am using Sharepoint 2010.  I have several lists whose view includes the column "Edit (Link to Item)" in the default view.  I am the site admin so when I view the list the "Edit" column appears with the small "paper and pencil" icon and it works when clicked. 

I needed some users to only be able to view and edit existing items (not add or delete).  So I have created a site level permissions that I copied from "Read" and only checked the "Edit Items  -  Edit items in lists, edit documents in document libraries, and customize Web Part Pages in document libraries" under Lists. 

This new permission level does allow users to see the edit menu item on the standard "Title" hyperlink dropdown, but in the"Edit" column there isn't an icon or any clickable link to edit in the column.  Only from the menu.  Its as if the icon won't appear if I don't give them Add capability which is what I don't want.

 Thanks for any tips,

VA

 

 

 

---

va

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

Learn to create SharePoint 2010 Web Parts that query multiple lists by using LINQ.

Learn to create a Silverlight application that displays SharePoint 2010 lists inside DataGrid controls.

Learn how to use the REST API to retrieve resources such as ranges, charts, tables, and PivotTables from workbooks stored on SharePoint Server 2010.

Watch a short video that shows how to programatically retrieve data from an Excel workbook.