'Open with Access' option disabled in SharePoint online

Question

_{Thursday, September 15, 2016 7:23 AM}

Hi,

I want to access the data from SQL to SharePoint Online. I have admin account in SharePoint online. Created the custom list, but i couldn't find the 'Open With Access' option enabled in my account. How can i enable this option?

Thanks in advance.

All replies (4)

_{Monday, September 19, 2016 8:45 AM ✅Answered}

Hi,

There are some reasons why the “Open with Access” button is not enabled:

a. Microsoft Access 2013 application is not installed in the client computer.

b. Microsoft Access 2013 application is installed on the client computer, but ActiveX control (OWSSUPP.dll) is disabled.

c. User doesn't have enough permission to perform modification to the list.

If the issue still occurs, please try to repair your Office and add SharePoint site to trusted sites. And provide the version of your Office and browser.

A similar post for your reference:

http://answers.microsoft.com/en-us/msoffice/forum/all/sharepoint-online-open-with-access-disabled-with/00d884ea-efe8-4bd4-8a30-e038edb5a68c?auth=1

Thanks,

Dean Wang

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact [email protected]

_{Thursday, September 15, 2016 7:51 AM}

Please try to install KB 2553170 to resolve this issue.

_{Thursday, September 15, 2016 8:43 AM | 1 vote}

Hi Shelly,

I am using office 365 SharePoint online. I can able to view the 'open with access' link in Internet explorer, but not in other browsers. 

Thanks.

_{Monday, August 12, 2019 9:16 AM}

really great hint!