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

Clark Labs

September 05, 2024 19:01

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://download.cnet.com/microsoft-access-database-engine-2010-redistributable-32-bit/3000-10254_4-75452795.html?rex=true

https://www.dropbox.com/scl/fi/7as7u39dc94js44q6esss/AccessDatabaseEngine.exe?rlkey=niiyfna0nuk1p502r2pfsq0xa&st=cr7ykas4&dl=0

(The original link is no longer valid: 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

14 Comments

Date Votes

0

Paegelow February 22, 2016 17:10

Dear Clarklabs staff,

thank you for the efficient and rapid response.

Best regards

Martin

Comment actions Permalink
0

Gherardo Chirici July 18, 2016 12:59

Yes the solution works fine!

Comment actions Permalink
0

Clark Labs March 28, 2017 18:23

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.

Comment actions Permalink
0

Matthew Irwin January 24, 2020 00:47

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)

Comment actions Permalink
0

Clark Labs January 24, 2020 18:44

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

Comment actions Permalink
0

Matthew Irwin January 26, 2020 22:28

Comment actions Permalink
0

Matthew Irwin February 03, 2020 21:54

any progress on this?

Comment actions Permalink
0

banata wachid ridwan February 16, 2020 07:42

anyone can confirm this trick?:

https://techblog.aimms.com/2014/10/27/installing-32-bit-and-64-bit-microsoft-access-drivers-next-to-each-other/

on my case, this trick works

Edited by banata wachid ridwan February 16, 2020 14:57

Comment actions Permalink
0

Faridah Bukirwa March 12, 2020 18:26

I am getting a similar error like Mathew above, I have reinstalled 32-byte Office System Drivers via https://www.microsoft.com/en-us/download/details.aspx?id=13255

However, i still cant open any dbf.files under TerrSet. Any help

Comment actions Permalink
0

Patricia Ruiz April 20, 2020 19:34

I got the same problem as Matthew with that messahe popping up. I just tried uninstalling manually the Microsoft Access Database Engine version I had installed (Microsoft Access database engine 2010 (english)) and reinstalling the 32 bits one and it worked fine.

If it doesn't work for you I'll leave a link that might be helpful for your situation

https://social.msdn.microsoft.com/Forums/en-US/c159dec1-1b83-45e3-8493-9d3a8fbec4c2/microsoft-access-database-engine-2016-redistributable-wont-install-due-to-64bit-component?forum=officegeneral

Comment actions Permalink
0

Matthew Irwin April 20, 2020 20:07

Thanks Patricia - i will give that a go!!

Comment actions Permalink
0

Edward paul September 04, 2020 12:37

I too had stuck with this “.accdb in use” error. But after searching a lot I got some easy fixes to resolve it. Try it maybe it works for you too.

Access 3045-“Couldn’t Use Database; File Already In Use” Error

Comment actions Permalink
0

Josue Estrella Duran September 30, 2022 04:20

Hello, I have the same problem to import shape files to Terrset2020. I started installing the Microsoft's 2010 32-bit Office System Driver and then I follow the advice of all of you, but I can´t resolve this issue.

The operating system is windows 11 Home Edition, and the MS Office is a Home Edition too, so the MS Access is not installed.

Do you think I have to upgrade the MS Office Version?

Comment actions Permalink
0

Clark Labs September 05, 2024 18:58

The download link has been removed. But you can download the Microsoft 2010 32-bit redistributables either here:

https://download.cnet.com/microsoft-access-database-engine-2010-redistributable-32-bit/3000-10254_4-75452795.html?rex=true

or here:

https://www.dropbox.com/scl/fi/7as7u39dc94js44q6esss/AccessDatabaseEngine.exe?rlkey=niiyfna0nuk1p502r2pfsq0xa&st=cr7ykas4&dl=0

Comment actions Permalink

Please sign in to leave a comment.