HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"


  • NOTE: i have found hundreds of threads on this error, yet they all seem to suggest using the 'Microsoft access database engine'. however for whatever reason (even though its made for 64-bit office) this did not work on my machine so i was forced to find an alternate method.

    this resolution works with:

    • 64-bit Windows 7
    • 64-bit MS Office
    • Please reply to this thread if it worked for you so i can make this a full "compatibility list"


    trying to connect to an Access database in visual studio but keep getting this error?

    try installing this first: http://www.microsoft.com/download/en/details.aspx?id=13255


    however if, like me, that doesnt work for you, try the following method:

    NOTE: this DOES work for office 2010 even though it is for 2007 office, dont ask me why it just does :)

    1. download and install this: http://www.microsoft.com/download/en/confirmation.aspx?id=23734

    2. in VS click add data source, follow the wizard and enjoy! :)


    P.S thanks to everyone that helped me at my original thread: http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ebb05600-055a-44c4-8cd3-d33a79878b23

    i did give up and tried storing to text files, but oh my god was that a bad choice! so i came back to trying to resolve this and managed to after HOURS AND HOURS of searching.

    this thread is for all of those people being given a hard time connecting to Access databases!

    Please share your opinions/ problems below!

    • แก้ไขโดย MaxJordan91 10 ธันวาคม 2554 12:53
    10 ธันวาคม 2554 12:51