DataSheet view in SharePoint 2010 with Office 64-bit
My notebook runs 64-bit Windows 7. That’s cool, because you can develop SharePoint 2010 stuff on it without the need to run a virtual machine (which eats up extra memory slowing the whole thing down again). But I had some troubles with SharePoint 2010 and Office 2010 64-bit. The datasheet view, which you can use to view a list in access style (bulk edit) didn’t work, something with the nescessary components not being installed.
After some Googling, I found this post at MSDN: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/9eb920ba-1a02-4f0c-ae08-6e808e0269c4/. With the help of Jennie we managed to find a solution in installing the “2007 Office System Driver: Data Connectivity Components”. You need to do this AFTER you install Office 2010. Once you’ve got the 2007 bits installed, the 2010 installers will refuse installing because it finds some 2007 left over components installed on your system (even if you want them to be there).
Thumbs up and thanks to Jennie for providing us with a quick fix for this pressing item. I’m not always satisfied with the attention Microsoft brings to the MSDN forums, but this one was handled quite nicely!