PowerShell, SharePoint, & MS Access – Oh My!


I’ve been getting into PowerShell scripting a lot at one my clients and I encountered a pretty unique situation that I spent days trying to find the answer to.  I figure I would post a quick note about it and see if I could save someone else some time.


The setup:

One of the tasks I have at this client is to put together a weekly Status Report MS Word document for management.  Although I try to keep the information brief, we are running about 7-8 pages in length (we have a lot of  plates spinning at the same time.)  I have to follow up with a dozen people to get their updates.  Although I’ve tried to get them to submit their information in a standardize format, etc, the information comes in wildly different formats, completeness, or lacks context, etc.  The entire process can take a few hours to pull together – depending on the editing required.  I thought that a better use of time was to come up with a SharePoint solution that would allow everyone to contribute their portion of the status report and have an automated weekly report generated automatically for management.

The Issue:

After setting up my SharePoint site/list, creating the MS Access database, and connecting it to said list, automating MS Access from PowerShell as a scheduled task on a server proved to be quite challenging.  There were a number of error messages and access issues that needed to be addressed before everything worked.

Read more

Really IE? Really? Shouldn’t more bits be better?

Difference between 64-bit IE and 32-bit IE

IE, aka the Bane of the Web, has struck again!  This time with it’s own Microsoft products!  (Okay “Bane of the Web” is maybe a bit much – just so frustrated with it right now.)

Just a quick note – if you are using the 64-bit version of IE (which should be “better”, no?), and you are encountering some issues with SharePoint, try switching back to the 32-bit version.  You’ll be amazed as things just start working. (grumble… grumble.)

Recently I spent enough time trying to resolve this issue it was worth a blog posting. I was trying to open a Sharepoint 2010 site in Explorer. I could do this without any issue on laptop. However on my desktop, the option was greyed out. After some googling around, I hit on this answer at SharePoint Stack Exchange. (Thanks guys!)

Difference between 64-bit IE and 32-bit IE
Difference between 64-bit IE and 32-bit IE

You may want to create a shortcut to the 32-bit version of IE on your desktop. You can generally find the 32-bit version at C:\Program Files(x86)\Internet Explorer\.


Latest Challenge: SharePoint, jQuery, and Web Services

Back again!

I don’t write as often as I should and with the new year coming up, I’m hoping to change that (again!)

In keeping with what I’ve been blogging about in the past, I decided to write about my latest challenge/adventure. The last few years I’ve been concentrating on Project Management and not really writing a lot of code.  However, PM’ing at my latest client has given me tons of programming opportunities if I want to pitch in and help.  Lots of PowerShell, Exchange, and Active Directory stuff (with some sprinkling of other types of stuff like SharePoint and faxing, etc.)  My latest challenge is creating a dashboard of the data we’ve collected on the Exchange mailboxes.

Read more

Hackintosh Upgrade 2013 – Part 1 Research


I haven’t written to the blog lately – I’ve been more of a consumer of knowledge and really haven’t contributed anything much. I’m hoping to change this stance as lately I’ve found myself referring back to my blog entries as my own personal documentation. So I figure, why not spend a few minutes to document my stuff and create a blog post while I’m at it?

I’ve been getting into two different services that really have help me out in organizing my entertainment – Calibre and Plex. Calibre is an ebook management system and Plex manages all my audio and video items. I’ve centralized everything onto my Ubuntu server in my home office. Unfortunately, the server hardware was damage due to a loose cpu heatsink. The server would reboot every 5-10 minutes when the system was under load. This is a major issue when I got the entire family gathered around to watch a movie. It was time for some replacement parts.

Read more

Silverlight Already Installed

Silverlight.pngSilverlight for some reason decided to take a Holiday during my Holiday. Ever eager to solve a technical issue during family events, I decided to start looking around for a solution. The installer package kept telling me I had a later version of Silverlight already installed. Very frustrating.
After about an hour goggling and trying a ton of different things, I came across something that was very close to the answer:


Talking Moose detailed a pretty good uninstall instructions. Even after following the all the steps I still had the same issue. I had to resort to the manual removal method… with a slight twist.

Read more