Upgrading Excel

The software uses Microsoft Excel as its primary data source and reporting platform.

Microsoft Excel can be installed as either a 32-bit or 64-bit application. The software determines between these versions when it is originally installed.

If Microsoft Excel 32-bit is subsequently uninstalled and replaced with Microsoft Excel 64-bit (or Microsoft Excel 64-bit is replaced with the 32-bit version) an incompatibility with the Microsoft Access Database Engine will occur.

To fix this incompatibility the versions of both the Microsoft Access Database Engine and the Software Interface will need to be changed if Microsoft Excel is upgraded from 32-bit to 64-bit.

After Microsoft Excel has been reinstalled, each of the steps below needs to be followed.

Close All Open Applications


Before proceeding further it is important that all open applications and windows such as Excel and Outlook etc are closed apart from the internet browser showing these instructions. There should be no other applications running on the desktop before continuing. All Tigermoth windows and instances should also be closed.

Download the Database Engine


Download the Database Engine from the link below and save it to a temporary location on your machine's local drive (C drive). The example in these instructions shows the location that the file is saved to as being C:\Temp.

Make sure that you choose the correct version of the Database Engine that aligns with the new version of Microsoft Excel that has been installed. A link to instructions on how to find this information is below.

Is Microsoft Excel a 32-bit or 64-bit Installation?

If you are now running Excel 32-bit choose the file called AccessDatabaseEngine.exe

If you are now running Excel 64-bit choose the file called AccessDatabaseEngine_x64.exe

The correct link to the Microsoft Access Database Engine 2010 is below.

Microsoft Access Database Engine 2010 Redistributable

WARNING

THE CORRECT VERSION OF THE ACCESS DATABASE ENGINE IS 2010 SERVICE PACK 2. DO NOT DOWNLOAD ANY OTHER VERSION SUCH AS ACCESS DATABASE ENGINE 2016 ETC.

Administrator Command Prompt


The Microsoft Access Database Engine needs to be manually installed via a Windows Command Prompt with local Administrator rights. The system will ask for a local Administrator user name and password if your standard user name does not have local Administrator rights.

To open a Command Prompt with local Administrator rights click on the Windows Search icon at the bottom left of the Windows Desktop. Then type CMD in the search bar. This will then show the Command Prompt app. Select the option titled Run as Administrator as shown below.



Install the Database Engine


Type each of the three commands shown below and press Enter after each.

If the name of the directory is different from the example value of C:\Temp then replace this example directory value with the directory location of the AccessDatabaseEngine_x64.exe

The commands that need to be issued are shown below:

CD\
CD Temp
AccessDatabaseEngine_x64 /passive




Note that if these commands are successful there will not be a notification of such to the end-user. During the Database Engine installation a window should open and then automatically close. A notification will be given only if an error is encountered.

Uninstall the Software Interface


Click on the Windows Start Button at the bottom left and start the Tigermoth/Uninstall app. Follow the prompts to proceed and remove the Tigermoth Software Interface.

Do not remove the Tigermoth RunTime Environment via the Windows Control Panel app. The RTE component should never be altered, changed or uninstalled.



Request the Software Interface


The Software Interface needs to be installed for each user of a machine. The installation file for the Software Interface does not need full Administrator rights. The Software Interface should be installed by the end user when they are logged into the machine using their standard username.

It is important to request the correct version of the Software Interface according to the version of Microsoft Excel that is installed, i.e. is Excel 32-bit or 64-bit? A link to instructions on how to find this information is below.

Is Microsoft Excel a 32-bit or 64-bit Installation?

Use the key combination ALT+PRINT SCREEN to create a screenshot of the active window showing if Microsoft Excel is 32-bit or 64-bit and paste it into the email request for the interface. You can click on the link below to generate an email request for the Software Interface.

Request the Installation Files for the Tigermoth Interface

An example of an email request correctly showing the version of Excel is below.



Install the Software Interface


A link to the correct version of the Software Interface will be returned via email. Download the installation file to the local machine's hard drive (for example to C:\Temp) and then double click this file to begin the software installation. Do not save and run the Software Interface installation file from a network drive.

The default installation directory is %LOCALAPPDATA% which maps to the end user's local profile. This is the recommended location for installation because the interface does not require local administrator rights to install and does not need to access the local machine's registry.

In some enterprise environments users cannot use the default location to run executable applications, or the end user's profiles are located on a network drive. In these situations the software should be located in the directory C:\Tigermoth.

It is strongly recommended that the software is not installed into the directory C:\Program Files because end users will require Administrator rights to update the software at a later stage.

Click Install to unpack and install the Software Interface. Further licensing of the software is not necessary when the Software Interface is simply uninstalled and reinstalled.