none
Oledb error RRS feed

  • Question

  • The 'microsoft.ace.oledb.12.0' provider is not registered on the local machine".

    Have someone meet this issue before?

    How to fix it?

    Wednesday, December 21, 2016 5:06 AM

Answers

  • Wednesday, December 21, 2016 6:07 AM
    Answerer
  • Hi ,

    Mostly we use Office 2007 or Office 2010, So we used Provider=Microsoft.ACE.OLEDB.12.0 like your code.

    About where can I get the ACE Engine?

    To run the code samples provided must have the ACE engine on your computer which means that you must install one of the following Access 2010 (or Office Access 2007) products:

    From above information, using office 2007 or office 2010, our connection information is Microsoft.ACE.OLEDB.12.0.

    Best regards,

    Kristin


    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, December 21, 2016 9:38 AM

All replies

  • Wednesday, December 21, 2016 6:07 AM
    Answerer
  • Hi ,

    Mostly we use Office 2007 or Office 2010, So we used Provider=Microsoft.ACE.OLEDB.12.0 like your code.

    About where can I get the ACE Engine?

    To run the code samples provided must have the ACE engine on your computer which means that you must install one of the following Access 2010 (or Office Access 2007) products:

    From above information, using office 2007 or office 2010, our connection information is Microsoft.ACE.OLEDB.12.0.

    Best regards,

    Kristin


    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, December 21, 2016 9:38 AM