You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010
Symptom
You cannot view a list in Datasheet view on a SharePoint website after you install the 64-bit version of Microsoft Office 2010.
When you click Actions and then click Edit in Datasheet on a SharePoint 2003 or 2007 site, or you click the List tab and then click Datasheet view on a SharePoint 2010 site, you receive the following error message:
The list cannot be displayed in Datasheet view for one or more of the following reasons:
• A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
• Your Web browser does not support ActiveX controls.
• A component is not properly configured for 32-bit or 64-bit support.
Solution
Install the 2007 Office System Driver: Data Connectivity Components
Windows 7 prompting for credentials when accessing SharePoint documents
Sympton
You are prompted to enter your credentials, even though the user account that you are using has sufficient permission to access this site.
For example, when you open a Microsoft Office file from a Microsoft Office SharePoint site by using 2007 Microsoft Office on a Windows 7-based client computer that has no proxy configured, you are prompted for authentication.
Solution
you have to create a registry entry. To do this, follow these steps:
- Click Start, type regedit in the Start Search box, and then press ENTER.
- Locate and then click the following registry subkey:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
- On the Edit menu, point to New, and then click Multi-String Value.
- Type AuthForwardServerList, and then press ENTER.
- On the Edit menu, click Modify.
- In the Value data box, type the URL of the server that hosts the Web share, and then click OK.Note You can also type a list of URLs in the Value data box. For more information, see the "Sample URL list" section in this article.
- Exit Registry Editor.
- Restart the WebDAV service.
- Open an elevated command prompt and type in net stop WebClient && net start WebClient
- Reconnect to your SharePoint site.
Add a PDF icon to PDF documents in SharePoint 2010
By default SharePoint uses a white icon for PDF documents. It's rather plain. To use a PDF icon follow these steps...
Download the PDF icon to your SharePoint server.
Navigate to C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\IMAGES
Place the image in the IMAGES folder and name it icpdf.gif
Edit C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\XML\DocIcon.xml
Insert <Mapping Key=”pdf” Value=”icpdf.gif”/> between the following lines...
<Mapping Key="onetoc2" Value="icont.png" EditText="Microsoft OneNote" OpenControl="SharePoint.OpenDocuments"/>
<Mapping Key=”pdf” Value=”icpdf.gif”/>
<Mapping Key="png" Value="icpng.gif"/>
Save the file and restart IIS.
Update: Make sure the quotes are correct when you paste the text into the configuration file. Compare them with the rest of the quotes in the document.
Source: http://www.sharepointedutech.com/2010/02/17/changing-file-associations-icons-in-sharepoint-2010/
