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:
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.
Dear Clarklabs staff,
Yes the solution works fine!
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.
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)
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.
any progress on this?
anyone can confirm this trick?:
on my case, this trick works
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
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
Thanks Patricia - i will give that a go!!
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
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?