none
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.

    Wednesday, March 8, 2017 6:42 AM

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.

    Wednesday, March 8, 2017 7:33 AM
    Moderator
  • I installed it but it's the same error.
    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
    Friday, March 10, 2017 4:09 AM
  • 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.

    Tuesday, March 21, 2017 8:01 AM
    Moderator
  • If you are working with a .NET project then make sure the Platform is set to x86 (32-bit).

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Tuesday, March 21, 2017 1:13 PM
  • Is there a link to fix this error for office 2016?
    Monday, November 13, 2017 5:06 AM
  • 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 ? 

    Monday, March 5, 2018 7:22 AM
  • 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)

    Monday, March 5, 2018 1:47 PM
  • 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

    Tuesday, March 6, 2018 12:07 AM
  • 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)

    Tuesday, March 6, 2018 12:41 AM
  • 32-bit.
    Tuesday, March 6, 2018 2:36 AM
  • 32-bit.

    You can't use 32-bit SSMS with the 64-bit ACE OLEDB Provider. You might want to try installing the 2007 version which is 32-bit only:

    https://www.microsoft.com/en-us/download/details.aspx?id=23734


    Paul ~~~~ Microsoft MVP (Visual Basic)

    Tuesday, March 6, 2018 3:09 AM
  • 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 Madfox48 Monday, May 6, 2019 9:44 AM
    • Unproposed as answer by Madfox48 Monday, May 6, 2019 9:44 AM
    Saturday, March 30, 2019 4:44 PM
  • 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

    Monday, May 6, 2019 9:48 AM
  • I Installed 32 bit microsoft sql server
    Thursday, May 9, 2019 5:44 AM
  • How to download?
    Tuesday, June 11, 2019 12:09 PM
  • Thank you, thank you, thank you Paul. Your information was exactly the problem after installing the AccessDatabaseEngine and rebooting. You are an MVP!

    Matt-

    Thursday, September 19, 2019 7:14 AM