Recently, I changed to Office 2010 (Prof, x64) edition. I fully uninstalled Office 2007 and installed Office 2010.
Then the following error shows up when using the datasheet view:
The list cannot be displayed in Datasheet view for one or more of the following reasons:
- A datasheet component compatible with Windows SharePoint Services is not installed.
- Your Web browser does not support ActiveX controls.
- Support for ActiveX controls is disabled.
To my surprise, the solution is to install 2007 Office System Driver: Data Connectivity Components, or with other words the Access Database Engine.
So if you love surprises, start working with SharePoint and Office ;)
BTW, I am working with IE8.