Leaders in Innovative Research Solutions

Blog

Using Excel within MRDCL script

MRDCL and Access Runtimes

Many users of MRDCL make use of the Excel Productivity Scripting (EPS) tools within the program. The tools enable users to control parts of a project from MRDCL so that templates can be used and automation can be used to improve efficiency.

As MRDCL contains functionality to connect and read data from Excel, you are required to install the Microsoft Access Runtimes for this to work correctly. Without these runtimes you maybe presented with an error message "Unable to load obdcji32.dll".

Depending on your Office version, targeted platform, and Office installation method, there is a different compatible version of the Access Runtimes that you will need to download and install. You may find the targeted platform of your Office installation within the add/remove programs section of control panel, if you do not already know this. For a 32bit (x86) installation, a 32bit version of the runtimes should be installed. Likewise for a 64bit (x64) installation, you must install a 64bit version of the runtimes.

Office 2016

If you have installed office using a click to run package (such as Office 365), you will need to install the Access 2013 runtimes because the Access 2016 runtimes are only compatible with the MSI version of the Office 2016 installer.

Download the Access 2016 runtimes here
Download the Access 2013 runtimes here

Office 2013

For Office 2013, the Access 2013 runtimes will work with both the click to run and MSI Office installers.

Download the Access 2013 runtimes here

Office 2010

If you are still using Office 2010, you will need to install the Microsoft Access Database Engine Redistributable which can be downloaded from here

For further information or assistance, please contact tom.stone@mrdcsoftware.com

5 ways to make MRDCL runs faster

Phil Hearn
Author: Phil Hearn - Date posted: 29 June 2016
Tags: excel, mrdcl - Category: data-analysis

« The best survey software programs - How to deal with the problems of employee survey feedback reporting »