Here recently I had been working on organizing some content under SharePoint 2010 and I kept running across this error when trying to open a list or library in the datasheet view:
This was frustrating so I went to MSDN and fortunately a good discussion was done over this topic:
Thanks to Jenny E for the answer, but to recap, the solution for me was to install the 2007 Office System Driver: Data Connectivity Components.
After I installed the AccessDatabaseEngine.exe file locally and exited and cleared my IE cache, it works perfectly!
I can now edit my lists and libraries in the data sheet view under IE9 x64 version.