Error when trying to open list with "Open with Access" option

Question

SharePoint 2010 Enterprise with SP2 installed.

We have a standard OOTB SharePoint List and are trying to "Open with Access" enter image description here

The problem is when we click the "Open with Access" button in the ribbon, we get an error message:

enter image description here

Can someone please help me figure out how to get rid of this message and allow me to open this list in Access?

Thanks, -Rounn

their are couple of reasons for this issue, may be you dont have Office client on the pc or webclient service not running etc...check this curah.microsoft.com/27283/… — Waqas Sarwar MVP
– Waqas Sarwar MVP ♦, Commented Apr 7, 2015 at 16:48
Thanks, I am able to "Export to Excel" just fine, just not Access. For me, it seems to be related to 64bit Office vs 32bit Office. Still looking into it. — Haroun A.
– Haroun A., Commented Apr 8, 2015 at 19:39

Per Jakobsen · Accepted Answer · 2015-04-25 18:22:26Z

It is one of the limitations Microsoft clearly states as why you should use 32 bit office instead of 64 bit.

And in your bounty you mention

It currenty only works for 32bit office. The majority of the users I support are on 64 bit Office.

Nk SP · Accepted Answer · 2015-04-24 20:44:03Z

It seems and issue fixed by a hotfix for 32-bit Office.
you can download the hotfix here:

Install it and restart you pc.

Waqas Sarwar MVP · Accepted Answer · 2015-04-29 04:34:22Z

As I mentioned in comment, this is known limitation in Office 64bit. Datasheet view, open with access are not working with office 2010 x64.

Did you try to install Data Connectivity Components? install this on test machine and test it.

Rusty · Accepted Answer · 2015-04-24 20:34:53Z

Might want to try in a different browser.. I sometimes get this error in Google Chrome, but it will work fine in Internet Explorer. Not sure why..

4 Answers 4