MS Access 2010 to SharePoint 2010 error: Data cannot be inserted because there is no matching record.

We saw the below error message, when I try to update a record in SharePoint 2010 List which is linked up with MS Access 2010. I have 100s of records out of them only one record is giving us this error message. 

Error: Data cannot be inserted because there is no matching record.

In the MS Access if I go to the Linked Table (SharePoint List in MS Access) and just modify the record (uncheck and check a status record and revert it back), then everything works fine. It seems that particular record was not syncing with Server SharePoint List item/record.

Instead what I did is, I went to the table in MS Access, Right Clicked on the table and More Options than clicked on Relink Lists. Then it worked. I saved this version of MS Access db as new version and send across to the user.

http://stackoverflow.com/questions/3791372/data-update-error-with-sharepoint-2010-and-ms-access-2010

Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator.

While configuring the performance point 2010 I got the following issue

Cannot complete this action as the Secure Store Shared Service is not responding. Please contact your administrator.

After trying many approaches, I found the solution

1. Make sure the SecurityTokenServiceApplicationPool is running.

2. Go to System Settings -> Manage services on server

Following services should be enabled

PerformancePoint Service

Secure Store Service

Claims to Windows Token Service

3. Go to Application Management -> Manage service applications

4. Check the Secure Store is started

5. Go to App-pool and make sure the the associated App pool is running

6. Reset the IIS

SharePoint : Limited Access

Microsoft:

The Limited Access permission level is designed to be combined with fine-grained permissions to give users access to a specific list, document library, item, or document, without giving them access to the entire site. However, to access a list or library, for example, a user must have permission to open the parent Web site and read shared data such as the theme and navigation bars of the Web site. The Limited Access permission level cannot be customized or deleted.

 NOTE   You cannot assign this permission level to users or SharePoint groups. Instead, Windows SharePoint Services 3.0 automatically assigns this permission level to users and SharePoint groups when you grant them access to an object on your site that requires that they have access to a higher level object on which they do not have permissions. For example, if you grant users access to an item in a list and they do not have access to the list itself, Windows SharePoint Services 3.0 automatically grants them Limited Access on the list, and also the site, if needed.

Click here to see more --> on this.

So don't delete Limited Access permissions from your site as it wont harm you or your site.

The SSP Timer Job Distribution List Import Job was not run and other errors...

SharePoint error in the event viewer logs.

The SSP Timer Job Distribution List Import Job was not run.
Reason: Logon failure: unknown user name or bad password

I have run into this problem even when I have not changed the password.  I tried the fix to add the service account to the backup operators group and that did not completely fix the problem.  Additionally, I have notice that I have had a lot of other mysterious SharePoint Server Errors  What you need to do to correct this problem is:

1.     One of Microsoft’s best practices is to make sure that the application pool account for your SSP and your service account for the SSP are the same account.

2.     Make sure to add this account to the backup operator’s local group on all your SharePoint servers.

3.     If you are using Kerberos authentication for your web applications make sure you set your service name principle account for you ssp on you SharePoint application server.  In order to complete this operation you must install Window support tools from your Windows server installation files under support>>tools>>supporttools.msi.  Once you have installed the support tools go to start>>All programs>> Windows support tools>> command prompt.

setspn.exe –A HTTP/name_of_ssp_address domain\appication

Assume your site address is ssp, your domain is sharePoint, and your application pool account is svc_ssp. Run these commands

setspn.exe –A HTTP/ssp SharePoint\svc_ssp       (Run this Command)

setspn.exe –A HTTP/ssp.sharepoint.com SharePoint\svc_ssp  (Run this command)

If you are using Kerberos authentication on any of your web applications you must run these commands for the web applications to function properly including your central administration site.

4.     Check your system event logs on your SharePoint server for any DCOM errors.  You will notice your DCOM errors are associated with your application pool accounts.  Add these acounts to the IIS WAMREG admin service.  Make sure the accounts have local launch, remote launch, local activation, and remote activation.

5.     Next stop your Office SharePoint Server Search through central administation>> operations>> Services on Server.

6.     Then go to central administration>> operations>> service accounts.  Click on web application pool.  Then under web service choose Windows SharePoint Service Web application.  Next under application pool, choose your Shared Service Provider application pool account.  Under configurable you will notice that it populated your application pool account.  Now re-enter your password and click ok.

7.     Login into all your SharePoint servers and run iisreset /noforce.

8.     Go back to central administation>> operations>> Services on Server and restart your Office Server Search.

9.     Then go to central administation>>Application Management>> Manage this Farm's Shared Services.  click the drop down on the default SSP and click edit properties.  In the SSP service credentials enter username and password.  In the index server catagory select your index server and then click ok. Make sure you wait about 5 minutes.

Spent a lot of time trouble shooting the SharePoint errors and I hope this information helps.

Debug a SharePoint Class Library with VS 2008 or STSADM Project

Debug AudienceMigration Class Library Project:
Thanks to Magnum for the solution... see the below url for more inforation.

Solution:

1. Project configuration:

Change Debug and Build Configurations to Debug..

2. I was using a DLL called SharePoint.AudienceMigration.dll (Managed DLL for C#). I knew, however, that SharePoint.AudienceMigration.dll needed SharePoint.AudienceMigration.dll (Unmanaged C++) to operate. I placed SharePoint.AudienceMigration.dll in all my output paths but I kept receiving this error. Only after I placed SharePoint.AudienceMigration.dll in my environment path (C:\windows\Microsoft.Net\Framework\v2.0.50727) did it work. Please note: your path may be different if you're using a newer version of the .NET framework!

3. Build the project and buildwsp and deploy...
4. Move the SharePoint.AudienceMigration.dll to (C:\windows\Microsoft.Net\Framework\v2.0.50727) and also to (C:\windows\assembly)

5. Place breakpoints at start of the project and F5.

http://stackoverflow.com/questions/5181401/vs-2008-breakpoint-will-not-currently-be-hit-no-symbols-have-been-loaded-for-th

SharePoint 2010 Best Practices: Asset Versus Picture Library

If you have pictures, you have the choice to either store them in an asset library or a picture library. What is the best practice here?

Asset library (a media library)
More info about the asset library: http://office.microsoft.com/en-us/sharepoint-server-help/set-up-a-library-to-store-image-audio-or-video-files-HA101828004.aspx  Pros:
- Has in-built support for the new digital asset content types: image, video, and audio files.
- Has a default thumbnail-centric view.
- Has an image preview.
- Supports automatic metadata extractions (and promotion) for the following image types: BMP, GIF, ICO, JPEG, PNG, and TIFF.
- Podcasting support thru RSS feature.
- Supports metadata navigation (see https://www.nothingbutsharepoint.com/sites/eusp/Pages/SharePoint-Asset-Library.aspx  )
- Has a standard SharePoint 2010 menu (and therefore, has ribbon support).
-Centralized repository setup for digital assets (image, video, and audio files) for the organization.
- Allows Edit in Datasheet View, the Picture library does not. This makes bulk metadata management a lot easier.
Cons:
- Does not create a slide show of the pictures. This is an often used feature in Intranets. Example: A news article with a direct link to the slide show view of your company's last event or party.
- Although it is possible to email a link to the file (as is also the case in a Picture library), you can't easily embed them in an email or Word document. If you want to do this, you need to manually download the files you want to embed and add them manually to the email/document.
Picture library
More info about the picture library: http://agsci.psu.edu/it/how-to/use-picture-library-in-sharepoint-2007  Pros:
- Has a slideshow view of the pictures it contains.
- Can only contain pictures and is optimized for that.
- you can embed a picture directly into an email or Office document using the "Send To" action menu item.
- You can use the /_vti_bin/imaging.asmx web service to execute Upload/Download and other operations related to picture libraries: http://msdn.microsoft.com/en-us/library/imaging.imaging_members(v=office.12  ). Asset libraries don't have such a service.
With a Picture Library, users can easily send pictures (one or more) in an email (embedded in the body or as an attachment) or automatically add them to a Word document. With an Asset Library, users must download the files and manually create the email / document. Both have the option email a link to the file.
Cons:
- Does not have the larger thumbnail option of a picture when you hover over the item.
- The library menu is 2007 style, and thus looks different from other SharePoint 2010 libraries.
- Has a complicated way of uploading pictures using the "Picture Manager" application.

Conclusion
For pictures, the asset library represents the new choice towards the Digital Asset Management way of working SharePoint is striving towards. For pictures, it's the preferred choice, unless you really need a slideshow view. For other types of content, the asset library is the way to go.

Credits:
This Wiki page was inspired by the discussion at http://social.technet.microsoft.com/Forums/en-US/sharepoint2010general/thread/1272cf0c-095f-40d5-bde1-49f1fff70ba1Please note: Also check out the SharePoint 2010 Best Practice Overview page athttp://social.technet.microsoft.com/wiki/contents/articles/8666.sharepoint-2010-best-practices-en.aspx

More:

http://office.microsoft.com/en-us/windows-sharepoint-services-help/working-with-sharepoint-picture-libraries-HA001123335.aspx

https://www.nothingbutsharepoint.com/sites/eusp/Pages/An-Interesting-Thing-About-SharePoint-Picture-Libraries.aspx

Open an HTML or PDF files in SharePoint 2010

When you try to open a PDF file it prompts you to save it rather than opening.

This is a security feature of SharePoint 2010 by design which adds headers that force the browser to download certain types of files like PDF, HTML etc. The forced download improves security for the server by disallowing the automatic execution of Web Content that contributors upload. In 2010 where we have a JavaScript Object Model, this would be a big problem if we did not have this restriction in place. This should be disabled at web application level which means across all the site collections, we cannot do at site level or site collection level.
If we disable this feature, we might have issues mainly if users try to upload HTML or other files which contain some malicious scripts.
If we want to enable this, we need to make sure that the users are not uploading any scripts (mainly Javascript) directly to Production without any testing on TEST environments.
Never fear there is a solution. It’s in central admin.Go there and click ‘Manage Web Applications’
Click on the web app you want to change, and go to ‘General Settings’
Scroll down the list until you reach ‘Browser File Handling’
Change the radio box from Strict to Permissive.
Click ok.
Go back to your PDF document and click on it – and it will open up without forcing you to save it somewhere first.