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", ".accdb in use", 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 2010 32-bit Office System Driver: Data Connectivity Components found at:

https://www.microsoft.com/en-us/download/details.aspx?id=13255

This installs the 2010 32-bit ACE driver which is compatible with all later versions of Office MS Access. All 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

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

  • 0
    Avatar
    Matthew Irwin

    We have Office 365 64 bit and it doesn't allow the installation of the MS Access 32 bit drivers. Opening a database in the database workshop is giving the message "The selected/associated database file cannot be opening due to being out of memory...."

    We are running Windows 10 with Terrset 18.31, i also have the x64  Access DB engine installed (but this does not help)

     

     

  • 0
    Avatar
    Clark Labs

    Hi Matthew,

    Microsoft's 2010 32-bit Office System Driver is compatible with both of the 32-bit and 64-bit versions of Office. Try installing the 32-bit Office System Driver once more and please let us know if you experience any issues.

    Jamieson

     

  • 0
    Avatar
    Matthew Irwin

  • 0
    Avatar
    Matthew Irwin

    any progress on this?

  • 0
    Avatar
    banata wachid ridwan
    Edited by banata wachid ridwan
Please sign in to leave a comment.
Powered by Zendesk