2

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

  • 2
    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 Apr 7 '15 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. Apr 8 '15 at 19:39
4
+25

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

  • In SharePoint, the list view won’t be available.

See Choose the 32-bit or 64-bit version of Office on https://support.office.com

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.

|improve this answer|||||
1

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

Hotfix

Install it and restart you pc.

|improve this answer|||||
1

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.

https://support.office.com/en-us/article/Use-Datasheet-view-in-64-bit-Office-2010-f734e938-8baa-492e-84f4-85a7cc85645a?CorrelationId=76a84d60-b81a-4a7d-be8e-dd77a40b660e&ui=en-US&rs=en-US&ad=US

|improve this answer|||||
0

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..

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.