Fix “The Standard View of your list is being displayed because your browser does not support running ActiveX controls.”

Problem:
The datasheet view in SharePoint 2010 did not work with the message “The Standard View of your list is being displayed because your browser does not support running ActiveX controls.” in IE11 browser!

Solution:

• Add SharePoint site to compatibility view settings in your IE-11 browser. Furthermore, check the “Display intranet sites in Compatibility view” checkbox (My SharePoint site is under Intranet zone, BTW)

  

• Download and install the Access database engine: https://www.microsoft.com/en-in/download/details.aspx?id=13255