Cannot view datasheet view, IE9 64 Bit, Windows Server 2008 R2 under RDS.

Question

I've been doing a lot of reading on this problem.  When you attempt to view a data sheet you get this error:

 

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 prop

 

I went through all the standard fixes.  The server does not have 64 bit version of Office installed, not did it ever have any old version of Office ever installed.

 

Server 2008 R2 up to date

Office 2010 Standard SP1

Access 2010 installed separately with SP1

 

I have done a fix and repair on both Office and Access, no help.

I installed the Access 2007 and 2010 DB Engine on separate attempts.

 

None of the standard SharePoint controls work including Connect to Access or Open in Excel but Connect to Outlook does work.

 

What is confusing is that Microsoft states that IE9 is 64 bit only on Server 2008 R2 and since we're running RDS that is the only option.

 

I deleted the OWSUPP.DLL and did  a Fix/Repair, no luck.

 

I attempted to register OWSUPP.DLL and get the error that the DLL failed to register with error 0x80070716.  That lead me to some posts about people who had installed Office 2003 in the past but this is a fresh server.  The user did also install an ODBC driver which I'm trying to confirm to see if it was based on an older version of Access or not.

 

I've found no answers and none of the standard fixes seem to work.  Any advice would be appreciated.

 

Thanks

 

Answer 1

IE9 64 bit doesn't support datasheet view on SharePoint 2010 because there is no 64 bit version of the active x control. See this post for details.

http://technet.microsoft.com/en-us/library/cc263526.aspx#section2

---

Doug Hemminger http://www.sharepointdoug.com

Answer 2

Hi,

I have noticed that flash also does not work in IE9(64). For the data sheet view you can use IE(32) exe. this gets installed automatically in your OS. From start menu go to "All program" then you can fined "Internet Explorer (64-bit)" and  "Internet Explorer" in the application list. select "Internet Explorer" to launch the IE this is a 32 bit IE. In this you will be able to open datasheet view.

-Pawan

Answer 3

We've developed an alternative to the Datasheet view, works in any browser and also supports custom fields.

If you want to check it out:

http://www.kwizcom.com/sharepoint-add-ons/list-in-line-editor/overview/

Cheers,

Nimrod Geva

Product Group Manager

KWizCom

Answer 4

You need to install the 2007 Office System Driver: Data Connectivity Components

http://www.microsoft.com/en-us/download/details.aspx?id=23734