Importing Shape and Database Workshop errors with Office 2010 64-bit, Office 2013 32- and 64 bit, and Office 2016

Shape Import/Export errors and Database Workshop errors opening a database with Microsoft Office version installed, 2010 64-bit/2013 32-bit/2013 64-bit/2016. Errors can also occur with Crop Suitability modeling in ESM.

Common error are: "Provider cannot be found. It may not be properly installed", "Out of Memory", or an error that the .accdb file cannot be found.  

With the release of 18.02, Shape is now working on machines with later versions Microsoft Office installed. However, data connectivity components from Microsoft will need to be installed, specifically:

Install Microsoft's 2007 Office System Driver: Data Connectivity Components found at:

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

This installs the 2007 ACE driver which is compatible with all later versions of Office MS Access and other Office products will continue to run.

This solution is due to issues with the ACE engine installed with Office 2010 64-bit and later versions reported by many developers, not just with TerrSet.

Have more questions? Submit a request

3 Comments

  • 0
    Avatar
    Paegelow

    Dear Clarklabs staff,

    thank you for the efficient and rapid response.
     
    Best regards
    Martin
  • 0
    Avatar
    Gherardo Chirici

    Yes the solution works fine!

  • 0
    Avatar
    Clark Labs

    With the latest release of 18.3, TerrSet requires that the ACE drivers be installed, regardless if Microsoft Office 2010 or 2013 is installed. This is due to a change in backwards compatibility for previous version of Microsoft Access drivers. 

Please sign in to leave a comment.
Powered by Zendesk