Javascript required
Skip to content Skip to sidebar Skip to footer
Home / How to Install Microsoft Ace Oledb 12.0

How to Install Microsoft Ace Oledb 12.0

RRS feed

  • Remove From My Forums

locked

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. RRS feed

  • Question

  • I installed Access. How do you fix this on Windows 10 64 bit pc, 32 bit Office 2016, Windows 10?
    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

All replies

  • Hi MinhL7,

    Because the provider hasn't been registered on the machine on which the application is running. 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.

    Best regards,

    Cole Wu

    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.

  • I installed it but it's the same error.
    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

  • Hi MinhL7,

    Do you install 32-bit component and restart your computer?

    Best regards,

    Cole Wu

    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.

  • If you are working with a .NET project then make sure the Platform is set to x86 (32-bit).

    Paul ~~~~ Microsoft MVP (Visual Basic)

  • Is there a link to fix this error for office 2016?

  • Is there a link to fix this error for office 2016?

    Hi MinhL7 ,

    I installed Access. How do you fix this on Windows 10 64 bit pc, 32 bit Office 2016, Windows 10?
    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    The same issue is facing by me right now, Have you got any solution regarding this issue ?

  • Is there a link to fix this error for office 2016?

    Hi MinhL7 ,

    I installed Access. How do you fix this on Windows 10 64 bit pc, 32 bit Office 2016, Windows 10?
    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    The same issue is facing by me right now, Have you got any solution regarding this issue ?

    See my answer below and also to your post.

    Paul ~~~~ Microsoft MVP (Visual Basic)

  • Hi Paul - I don't see your answer below.  I am trying to import data with SSMS and have this issue, again after installing AccessDatabaseEnginex64.  There isn't a 32-bit option, I'm on Win 10 and ALL my components are 64-bit (Office, IE, VS, etc.).  SSMS is v17.5.

    Any thoughts?

    Justyn

  • Hi Paul - I don't see your answer below.  I am trying to import data with SSMS and have this issue, again after installing AccessDatabaseEnginex64.  There isn't a 32-bit option, I'm on Win 10 and ALL my components are 64-bit (Office, IE, VS, etc.).  SSMS is v17.5.

    Any thoughts?

    Justyn

    My answer was for .NET, since it's a ADO.NET Managed Providers forum. Is your SSMS 32-bit or 64-bit?

    Paul ~~~~ Microsoft MVP (Visual Basic)

  • Hi,

    I've got the same problem - using Visual Studio 2017, 64 bit Office 365 and a laptop with an AMD 5 processor.

    I have installed the AccessDatabaseEngine 64 version but I am still getting the error.

    Any ideas?

    Thanks,

    Elsie

    • Proposed as answer by Monday, May 6, 2019 9:44 AM
    • Unproposed as answer by Madfox48 Monday, May 6, 2019 9:44 AM

  • Hi,

    I think you need to install the 32 bit version of the database engine.

    Indeed, VS works in 32 bit.

    i Advise you to install the X86 version of the databse engine but beware of conflicts between the 32 and 64 bits of Office.

    Madfox

  • I Installed 32 bit microsoft sql server

  • Thank you, thank you, thank you Paul. Your information was exactly the problem after installing the AccessDatabaseEngine and rebooting. You are an MVP!

    Matt-

How to Install Microsoft Ace Oledb 12.0

Source: https://social.msdn.microsoft.com/Forums/en-US/600c7fb6-e7af-4a72-9323-c80c379703d2/the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine