Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • alexant 22 posts 42 karma points
    Jan 05, 2015 @ 15:56
    alexant
    0

    Error validating the Data source: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

    Hi there!

    when I am trying to import the access database on my local machine, I get the following error:

    Error validating the Data source: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine


    What is wrong?

    Thanks kollege!

  • Richard Soeteman 4054 posts 12927 karma points MVP 3x
    Jan 05, 2015 @ 15:59
    Richard Soeteman
    0

    Hi,

    Access requires a server component being installed on the server check page 49 troubleshooting of the manual please

    http://soetemansoftware.nl/cmsimport/downloads

    Best,

    Richard

  • alexant 22 posts 42 karma points
    Jan 05, 2015 @ 17:24
    alexant
    0

    Thanks, it works!

    But now, after I did it I got the following Error:

    Error validating the Data source: Unrecognized database format 'C:\Users\......\app_data\cmsimport\68ac0aab-724c-49fd-bf89-ed2c25ca5b0f_Sprach.accdb'

    The fact is that the same access file is being importing without problems on the hosting website.

    I didn't an apropriate troubleshooting in the manual.

    thanks

  • Richard Soeteman 4054 posts 12927 karma points MVP 3x
    Jan 05, 2015 @ 17:39
    Richard Soeteman
    0

    Maybe the database is open in another app? And did you set 32 bits enabled on IIS and did you reboot after that?

  • alexant 22 posts 42 karma points
    Jan 05, 2015 @ 17:46
    alexant
    0

    Yes I did. 32 bits enabled, rebooted, so DB shouldn't be opened in any other process.

  • alexant 22 posts 42 karma points
    Jan 05, 2015 @ 19:03
    alexant
    0

    So I moved further. I think the mistake was in location path. I just moved the Site to the C:/ root.

    Now I get the following Error:

    Error validating the Data source: The Microsoft Office Access database engine cannot read the data in Land. The minimum required version to read the data is 14.0.0000.0000.

    ..I think I collect all the errors before I get it worked ))

    any idea on this one?

  • Richard Soeteman 4054 posts 12927 karma points MVP 3x
    Jan 06, 2015 @ 08:28
    Richard Soeteman
    0

    By google the error message it's about a higher version of access. I think the version mentioned in the manuals was for office 2007 but there is a higher version also http://www.microsoft.com/en-US/download/details.aspx?id=13255

    Hope this helps,

    Richard

  • alexant 22 posts 42 karma points
    Jan 06, 2015 @ 19:07
    alexant
    0

    That's it. Solved.

    thanks

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies