VERIFIED SOLUTION i
X

MapInfo Pro 15.2 x64 and error when running .mbx that updates Excel Data "The Microsoft ADO Engine is not available for error information" due to missing 64-bit Access driver

Issue

MapInfo Pro 15.2 x64 errors when running a custom .mbx that updates Excel Data:
"The Microsoft ADO Engine is not available for error information".

 

Cause

If a user has a 32-bit version of Microsoft Office, then the MapInfo Pro installer cannot install the needed
64-bit Access driver, due to Microsoft policy.
 

Resolution

UPDATED: April 5, 2017


64-bit vs 32-bit MS Access drivers
MapInfo Pro is a 64-bit application that can read spreadsheets and tables from Microsoft Excel and
Access. To do so you require the Microsoft Access database engine (x64). If you do not have this software
installed, the installer will prompt you if you would like it installed. However, if you already have the 32-bit
version (for example, installed as part of Microsoft Office) the MapInfo Pro installer will not be able to
install the 64-bit version of the database engine. One option is to uninstall the 32-bit Microsoft Access
database engine (for example, by uninstalling Microsoft Office) prior to installing MapInfo Pro 64-bit. This
is the recommended approach by Microsoft. If you require both versions of the Microsoft Office drivers
on the same system with MapInfo Pro, then follow the procedure below. It is recommended to put both
the 32-bit and 64-bit drivers on the same machine.
Installing 32- and 64-bit MS Office Drivers
MapInfo Pro is a 64-bit application that can access spreadsheets and tables from Microsoft Excel and
Access. To use data from Excel and Access within 64-bit MapInfo Pro, you must use the Microsoft Office
64-bit driver.
As part of the MapInfo Pro installation process, the 64-bit Microsoft Access Database Engine 2010
Redistributable for Office is installed if the Microsoft Access Database Engine 2010 32-bit driver is not
already installed on the system. The effect of this is, if 32-bit Microsoft Office is already installed on the
system, the MapInfo Pro installation process will not install the 64-bit Access Database Engine drivers
necessary for 64-bit MapInfo Pro access to Excel and Access.
If you require the 32-bit edition of Microsoft Office or its driver on the same system with 64-bit MapInfo
Pro, the following procedure shows you how to install both versions of Office drivers.
Microsoft does not support both drivers installed on the same computer citing incompatibility
between the product editions or their components. See http://support.microsoft.com/kb/2269468
for more details.

To install MS Office 32- and 64-bit drivers on the same system follow the procedure described below.
In order to perform this action, you need to have administrative rights to install or uninstall the software
on your computer. If you do not know if you have these rights, then contact your system administrator
for support before proceeding.
1. Download the MS Office drivers from
http://www.microsoft.com/en-ca/download/details.aspx?id=13255.
The 32-bit version is AccessDatabaseEngine.exe. The 64-bit version is
AccessDatabaseEngine_x64.exe.
2. Determine if you have the MS Office 2010 64-bit Office driver installed. You may already have it
installed if you have installed MapInfo Pro 64-bit. To ascertain if you have the MS Office 2010 64-bit
driver installed, open Windows Explorer and navigate to the folder C:\Program Files\Common
Files\microsoft shared\OFFICE14. If you have a file called ACEOLEDB.DLL installed, then
you have the 64-bit driver installed. If you have the file ACEOLEDB.DLL installed in C:\Program
Files (x86)\Common Files\microsoft shared\OFFICE14, then you have the 32-bit driver
installed.
The 32-bit driver is automatically installed if you already have 32-bit MS Office 2010 installed.
If you have the 64-bit driver installed, uninstall this driver, reboot the system, and proceed to
step 3. If you have the 32-bit driver installed go directly to step 4.
Note:
3. Install the 32-bit Office 2010 driver.
4. In the System folder (for example C:\Windows\System32), right-click on cmd.exe and select Run
as administrator.
5. At the command prompt navigate to the folder where the 64-bit Office 2010 driver is located. For
example, if you download the AccessDatabaseEngine_x64.exe and place it into the C:\temp
folder, then type cd C:\Temp in the command prompt, and hit the Enter key.
6. Type the command AccessDatabaseEngine_x64.exe /passive and and hit the Enter key.
7. If you have 32-bit Microsoft Office 2007, 2010 or 2013 installed on your system, open the registry
editor (in the command prompt you have open, type: regedit and hit the Enter key.) then check
the key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths.
If there is a registry value called mso.dll, then delete or rename it. If you do not delete or rename
the mso.dll registry value, you could get a Reconfiguring message every time you open up an
Office application.
Both drivers are now installed on your system..

 

 

Environment Details


 

Downloads

  • No Downloads