Datasheet view not working with Office 64-bit
Recently I reloaded my laptop, cleaned up most of my files and updated everything to the newest and shiniest. This was about 3 weeks ago, and this morning I got this nice message from SharePoint 2010:
The list is displayed in Standard view. It 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 browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled.
So what does that mean to me? Nothing to be quite honest, but there seems to be a 32-bit thing happening.
Now I know I only use Office 64-bit, always, and it might be something to do with that.
So along comes a KB article You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010, which seems exactly like what I am looking for. Looking at the error description below it seems to match what I am seeing in my browser.
The gist of the article is that Office 64-bit only installs the 64-bit drivers and if you are using a 32-bit browser, you will have some problems.
So download and install 2007 Office System Driver: Data Connectivity Components and your life will just be peachy.