none
Connecting to Access 2016 from .Net application RRS feed

  • Question

  • I am using the connection string "PROVIDER=Microsoft.ACE.OLEDB.12.0; to connect to an Access 2016 database

    but I get "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

    The solution seems to be to install "Microsoft Access Database Engine 2016 Redistributable 64-bit" and I downloaded it via the link

    <cite class="_Rm" style="color:#006621;font-style:normal;font-size:14px;"></cite>https://www.microsoft.com/en-gb/download/details.aspx?id=50040

    However, when I run it I  get

    Error message Click-to-Run : Office 365 - can't work with Installer

    How to I connect to the database? 

    Sunday, July 31, 2016 12:08 PM

Answers

  • Hi iLens,

    The following link provide a solution about this issue, please refer to:

    The ACE provider is not installed on Windows operating systems by default. You have to install it. The ACE provider is available in two forms: Microsoft Office Access database engine 2007 and  the Microsoft Access Database Engine 2010 Redistributable. The 2007 version is only available as a 32-bit component whereas the 2010 version offers both 32 and 64-bit options. You need to be careful which option you choose, because a wrong choice here is the most frequent cause for the error message.

    http://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

    Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. 

    Microsoft does not control these sites and has not tested any software or information found on these sites;Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information
    found there.

    There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Best regards,

    Cole Wu


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, August 1, 2016 2:17 AM
    Moderator