.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

Can not link from MS Access to SP admin lists

Posted By:      Posted Date: August 26, 2010    Points: 0   Category :SharePoint

We have WSS3. I am a site collection admin. The SP server is at remote location at our vendor.

I can link from MS Access to all the cusom lists - lists created by users.

I can not link from MS Access to the admin lists, for example the Site Hierarchy list. This is https://mysite.com/_layouts/vsubwebs.aspx

I know this is a LIST. It has columns Site URL, Title, etc.

I need Read only access. How can I do it?

View Complete Post

More Related Resource Links

Sharepoint 2010 - Lists not displaying Edit (Link to item) for Users with Edit Only access



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,






ASP.NET Allow Admin Users Access Basic Users Accounts


We have an ASP.Net web application currently released to the public, that uses Membership and Provider features and have our users assign to a "Basic" role.  What we are working on doing is developing an administrative site, so that administrators (presumably to be assigned an "Admin" role), are able to login to the administrative site, where they will have access to a list of users in the "Basic" role.
From the admin site, we want to allow the administrators to click on any of the "Basic" users and effectively be logged into there account (loading the user's profile information in the process, as is the case when a "Basic" user logs in), while still remaining lo

Video: The Access Show: Client Performance Improvements against SharePoint Lists

Today's guest is DJ Cole, architect and primary developer of SharePoint connectivity performance improvements on the Access development team. DJ dropped by to talk about how Access 2010 connects to SharePoint, and to discuss the work necessary for improving client-side performance. (Length: 13:05)

Remotely access winform application through admin panel

I am going to develop following application but not sure how to do this   Application will run different instances for various clients on different servers.     Each instance will run on different criteria stored in database managed by an admin.     Would like to be able to run this from the admin section.     Maybe using a server command line component and pipin the output into a web based admin? -- Whatever you think is best.     This application will run basically 24-7   Any best solution, idea etc

How to get rid of the (More Links.) link on lists in SharePoint 2010?

I have a list of 5 items. The view settings are set so that the Item Limit is 20. I would like the eliminate the (More Links...) link under the list when the web part is on the page. I also tried setting the Toolbar properties to No Toolbar. Any ideas? Thanks.

How to link SharePoint List with MS Access 2007 programmatically

Hi, can anybody tell me how to link SharePoint List with MS Access 2007 without opening Access environment. I want to do it programmatically through C#/VB.net doesn't matter. Your help will very much appreciated. Thank you so much! -Jarexs

Link Access 2007 to SharePoint 2007 Survey

So here is my problemo. I am trying to organize site requests into a system that will let us easially see what requests have come in and who are the particular owners or users associated with the requests. Currently we use a SharePoint 2007 Survey to collect all the requests. I was hoping to upgrade things by linking the Survey list to an Access 2007 db so we can manage the data better. However, whenever I attempt to link the Access DB to a SharePoint list, none of the survey lists show up. I was wondering if there was a way to make it so whenever someone completes a survey, it updates the Access DB. I have figured out a way to get this to work with InfoPath but I would rather use the surveys that already exist. Thank you, Jeb G.

Problems with access to external lists in SharePoint 2010

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?

Access to Central Admin, but receive error when accessing sites

We have a dev environment where we've reattached the config database and content databases. We can get into Central Admin, but none of the other SharePoint sites. Here is the error I see in the event log, which I believe indicates the cause of the trouble (see below). Any ideas on how to resolve? Thanks! Event Type: Warning Event Source: ASP.NET 2.0.50727.0 Event Category: Web Event Event ID: 1310 Date:  9/17/2010 Time:  9:45:53 AM User:  N/A Computer: SVUSFULSPWEBTST Description: Event code: 3006 Event message: A parser error has occurred. Event time: 9/17/2010 9:45:53 AM Event time (UTC): 9/17/2010 4:45:53 PM Event ID: 2767d864409a4d8380e5cb38fa987b21 Event sequence: 3 Event occurrence: 1 Event detail code: 0   Application information:     Application domain: /LM/W3SVC/482174774/Root-1-129292155459206250     Trust level: WSS_Minimal     Application Virtual Path: /     Application Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\collabtest.beckman.com80\     Machine name: SVUSFULSPWEBTST   Process information:     Process ID: 2192     Process name: w3wp.exe     Account name: GLOBAL\svcSPAppPoolTst   Exception information:     Exception type: HttpParseExce

Customized sharepoint portal is not accessible to normal users unless a site admin access the site o


Hello there

I have created a sharepoint portal and customized it. I have created my own master page and there are many webparts implemented. This has been hosted in a MOSS server. When a normal user is trying to access the portal first thing in the morning, he is getting a "You are not authorized to view this page" error. But when a site admin access the site, there is no issue and he is able to access the site. The site admin does nothing in the site and once he has logged in to the site,  the user is able to access the site without any trouble.

I have tried to look into the master page gallery and has given full access to the users for "Style Resource Readers" user group. Even now the user is facing the same issue.

Kindly help in this regards,



Windows PGM socket access error with non-admin account




I'm trying to use PGM sockets to send data. I can listen and receive data fine from a PGM socket using a non-admin account, but when I try to create a socket to send data I get an exception at this step:

socket.Bind(new IPEndPoint(IPAddress.Any, 0));

The exception is:

An attempt was made to access a socket in a way forbidden by its access permissions

Note that if I run the same code under an admin account it works fine. Is there a way to create a sender PGM socket without running under an admin account?

Add managed metadata column to list - access denied + terms not visible in lists


Firstly the following is not a problem for users given "Full Control" (and possibly other permission levels might work) at the web application level in central admin.

For any other user with permissions set at site collection level, even "site owners" (full control) , these problems arise.

  1. When adding managed metadata columns to a new document library list, clicking save results in multiple access denied errors getting logged (as seen using UlsViewer) and an exception is raised (sharepoint error page)
  2. In existing document library lists managed metadata column headings are displayed in list views but the terms text is not displayed.
This problem shows up even if the logged on user is the term set owner.  "Available for tagging" is enabled, submissions policy is closed.
Looking at http://<the-site-domain>/Lists/TaxonomyHiddenList/AllItems.aspx and then checking list permissions I can see that "All Authenticated Users" has Read permission level.
Integrated windows authentication - NTLM + Claims Based Authentication is the only authentication method used. It's an intranet site. 

Thanks in advance for any help.

Cross Access to Lists




I have lists in my teamsite A. Under the teamsite I have other teamsites (B and C) with lists.

Is it possible to have access from teamsite A to the lists in teamsite B or C ?

Thanx and regards


DBA needs to justify Local Admin access on SQL DB server to management



Can anybody point  me to documents that would substantiate the following assertion to my network manager:

"It's standard practice to have your SQL DBA administer the host server as  Windows local admin (a VM in this instance)."

My network & servers manager wants me to document why I, the DBA, need to have Local Admin access to the production database and reporting servers.  Part of the problem is that I sit with the application team, rather than net & servers.  However, I am an experienced production and development DBA in MS SQL Server (6.5 to 2008 R2) who has performed Windows local admin tasks in the past -- and will need to in the future.

Specifically I think I need local admin privileges in order to deploy and maintain the following:

SQL Agent b/u and maint. jobs; SSRS, SSIS, SSAS, 3rd party ETL (extract-transform-load), Log Shipping from production OLTP server to reporting server.  Creation of backup files on local disk.  SQL Server and OS performance monitoring.  Start and stop services.  Some Active Directory administration (for logins and groups)

Can anybody help me substantiate why I need local admin privileges on the database server -- even though I don't have formal Windows System Admin training, experience tells me I need local admin access in order t

Datasheet view, I get this error message: The lists are access DB lists.

  When I try to edit any of the lists by typing directly in the Datasheet view, I get this error message: The lists are access DB lists.

"An unexpected error has occurred. Changes to your data cannot be saved. For this error, you can retry or discard your changes."

I get this error message when I try to
1. add a new row by typing directly in the Datasheet view,
2. edit an existing row by typing (or selecting from a dropdown menu) directly in the Datasheet view, or
3. delete a row by right clicking on a row and selecting Delete Rows.

The error does not occur when I add new items to a list in the Datasheet view by clicking on one of the dropdown menus at the top of the list (such as New, and selecting New Item; or Actions, and selecting New Row). Using these options works fine for adding new rows, but I see no way now to edit or delete existing rows.

The problem seems to have developed sometime in the past few weeks.
I'm using Internet Explorer 7 with Windows XP Professional, Version 2002, Service Pack 3.

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


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

Opening an Access desktop app from a SharePoint link

I know we can create an Access web app that runs within SharePoint, and that's great.  But we're looking at our options for a specific situation.  Is it possible to put a link within SharePoint that opens an Access desktop app?  We tried putting a link to ACCDB and ACCDE files (in the same way as we can create links to Office files), but it didn't work.  Is there a way to do this?
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