Article: Microsoft Access Database Engine 2010 issue with gINT Civil Tools Professional



 

Problem Description

When trying to connect a gINT project database that uses an Access Database File, an error message stating a connection problem appears at the bottom of the gINT Connectivity dialogue

or

This file type requires the Microsoft Access Database Engine 2010 (64bit) to be installed.  Please contact your system administrator.

Reason

The Microsoft Jet database engine dates back to Windows 95 or earlier and was the original underlying database engine for *.mdb files created with Microsoft Access. Versions of Jet are contained in all editions of Microsoft Windows through Windows 7 and are used by 32-bit applications to connect to Access databases contained in *.mdb files.

 

Beginning in Office 2007, Microsoft Access gained a new file format with file extension *.accdb and additional functionality. Access to 2007 (and later) database files are supported by the new Microsoft ACE (Access Database Engine) driver.

 

The Microsoft Jet database engine is considered a deprecated product. Although it is still contained in Windows 7, no plans have been announced for it to be ported to a 64-bit version. There is currently an unfortunate limitation of the 64-bit ACE driver - it cannot co-exist with 32-bit versions of Microsoft Office.

 

When gINT Civil Tools Professional CONNECT Edition or gINT Civil Tools Professional Plus CONNECT Edition is installed on a machine with a 32b version of Microsoft Office it might create a problem with the reading of the Access database (gINT projects) which comes with the Microsoft Office suite.

 

Steps to Resolve

 

Option 1

The first option is to simply use the 64-bits version of the complete Microsoft Office suite. This way there won’t be any clash between 64-bits and 32-bits versions.

Option 2

To resolve the problem, the user has to re-install the Microsoft Access Database Engine 64bits. https://www.microsoft.com/en-us/download/details.aspx?id=13255 using the 'passive' option:

1:  Uninstall the Microsoft Access Database engine 2010

2. Open the Windows Command Prompt by typing "cmd" in the search box under the Windows Start menu.

3. Run the installation of the Microsoft Access database engine using the passive mode:

4. When the installation is complete, restart the computer and the connection to the database should be fixed.