locked
Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine error RRS feed

  • Question

  • My source code is written on the system that is the server with windows server 2008 R2 Enterprise . My app configuration is set to 'Any CPU' in VS2012. I have installed Microsoft Access 2007 64 bit on server. I am using Microsoft.ACE.OLEDB.12.0 as provider.  When I run the app from other computers in the network most of them can access the database and it is work without problem. but in some of clients this error occur:   'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine error. 

    any idea?

    Thanks



    Sunday, January 28, 2018 9:02 AM

All replies

  • It's possible that the problem computers are either not 64-bit, or simply don't have the Provider installed (it's not installed on a computer by default). Because your app has been developed with the x64 provider (and you have specified "AnyCPU"), there will be problems running on an x86 machine (which won't the x64 provider).

    Microsoft recommends sticking with the 32-bit version of Access when possible, possibly for this reason.

    If those problem computers *are* 32-bit, they may be able to install the 32-bit provider to solve the problem.

    This link is the download for 32-bit ACE.OLEDB.12.0 (which is for Access 2007) :
    https://www.microsoft.com/en-us/download/details.aspx?id=23734

    This link is also ACE.OLEDB.12.0 (for Access 2010). The only  difference I see in this second link is that there is also a x64 download in addition to the x86. What I don't know is whether or not the x86 version is the same as in the link above for Access 2007. The stuff that is written in the Details on this page make it sound like it'll work for older *and* recent versions of Access.
    https://www.microsoft.com/en-us/download/details.aspx?id=13255


    ~~Bonnie DeWitt [C# MVP]

    http://geek-goddess-bonnie.blogspot.com

    Sunday, January 28, 2018 5:53 PM
  • Hi aboozar_rahimi,

    Please check the following document.

    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.

    https://social.msdn.microsoft.com/Forums/en-US/a494006c-d77e-4c8f-aa1f-a9a6c5556c90/microsoftaceoledb120-provider-is-not-registered-on-the-local-machine-error?forum=adodotnetdataproviders

    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,

    Zhanglong


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Monday, January 29, 2018 1:10 AM