Archive for January 2011

How to connect Access to SharePoint 2010 if the feature within a view and/or list is missing.

Anyway, when I went to list view; the button to “Open with Access” was greyed out. I went into my settings and tried to create a new view with Access. It wasn’t there either.

Steps below:

  • So I opened up Access 2010.
  • Then chose the OPEN feature.
  • What is cool is in the drop down area; there was a item called, “SharePoint Foundation Services.”
  • I copied and pasted the URL to the SharePoint calendar that I needed to update…….

And then *POOF!* *MAGIC!* I can then update data via Access.

Happy SharePoint-ing!

Tony

SharePoint 2007 Error Message and Fix

Exception from HRESULT: 0x80040E14 error appeared on my SharePoint 2007 environment this weekend.

There are a variety of blogs I have found that fixes this issue.  Each one stating the same thing.

[box type=”info”]1. Check the drive space for the SQL server logs for SharePoint. Clean out the space.

2. Check the drive space for the SQL server data files for SharePoint. Clean out the space.[/box]

This fixed my issue.  I just wanted to pass along to my SharePoint community.  🙂

A must have PowerShell statement inside your PowerShell Script for SharePoint 2010

The past few weeks, I have been writting a lot of PowerShell scripts so I can automate as many SharePoint administrative tasks that I can so I can enjoy other aspects of SharePoint during the business day.  🙂

I found a must have statement from the book, “PowerShell for Microsoft SharePoint 2010 Administrators“, book.

Here is the statement.  This statement is important if you have a scheduled task or a program that kicks off programs.

I have a template now to make sure I have this statement right underneath my opening comments area. 

[box type=”info”]Example: If (-not(Get-PSSnapin | Where-Object { $_.Name -eq “Microsoft.SharePoint.PowerShell”})) {Add-PSSnapin Microsoft.SharePoint.PowerShell;}[/box]