none
help me ,, found error use ACE or JET, always like this RRS feed

  • Question


  • System.InvalidOperationException: 'The Microsoft.ACE.OLEDB.12.0' provider is not register on the local machine

    Application.Run(new Form1());

    sorry cannot contain images or links until able to verify my account.

    Friday, November 17, 2017 2:58 AM

All replies

  • If you are sure that you have installed the ACE provider, and it is still not being found, verify that the version that you installed has the same "bitness" as you program. That is, if your program runs in 64 bits, it will be looking for the 64-bit version of the ACE provider; it will not be able to find the 32 version if that is what you installed, and vice-versa.
    Friday, November 17, 2017 2:44 PM
    Moderator
  • Hello,

    Just checking in to see if you have attempted what Alberto suggested? The most common reasons for your current issue can usually be resolved with what Alberto mentioned.

    Personally, I'm on Windows 7 64 bit machine using the 32 bit provider from Microsoft with CPU set to any on the compile tab of a project.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Saturday, November 18, 2017 12:10 PM
    Moderator
  • Hello Ressal,

    Here's a discussion about this error, please refer to it and let me know whether it is worked for you.

    https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

    Sincerely,

    Fei Hu


    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.

    Sunday, November 19, 2017 8:24 AM
    Moderator
  • Hello Ressal,

    Do you have anything to update?  If you already have got the useful solution here, you could close the thread by marking the useful reply as answer, This can be beneficial to other community members reading this thread.

    Sincerely,
    Neil Hu


    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.


    Sunday, November 26, 2017 11:42 AM
    Moderator
  • Hi Ressal M N R,

    The ACE provider is not installed on Windows operating systems by default. we need to install it by manually. The ACE provider is available in two links: 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. Please be careful to choose, because a wrong choice here is the most frequent cause for the error message.

    Best regards,

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

    Friday, December 1, 2017 9:48 AM
    Moderator