Tuesday, June 22, 2010

PowerShell Tips for SharePoint 2007 and STSADM Lovers

Here is a quick guide for PowerShell tips in SharePoint 2010:

http://www.powergui.org/servlet/KbServlet/download/2812-102-4534/SharePoint2010PowerShell.pdf

And this Technet article gives a complete mapping of STSADM commands with PowerShell Commands:

http://technet.microsoft.com/en-us/library/ff621081.aspx

SharePoint 2010 DataSheet View - The list cannot be displayed in DataSheet view for one or more of the following reasons

After Installing Office 2010 if you try to use DatasheetView option in SharePoint 2010 List, you are thrown with a error:

The list cannot be displayed in DataSheet view for one or more of the following reasons: blah blah.....

For some reason Access is still relying on AccessDatabaseEngine which is a 2007 Office System Driver: Data Connectivity Components. Microsoft doesn't say much about this component as a prerequisite either.

Download and install this component and it will fix your error.

http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en