Reinstall Database Engine¶
The software uses Microsoft Excel as its primary data source and reporting platform.
Monthly Microsoft Office Updates for all versions of Microsoft Excel can corrupt existing installations of the Microsoft Access Database Engine. This is a known problem.
Also, if Microsoft Excel 32-bit is subsequently uninstalled and replaced with Excel 64-bit (or Excel 64-bit is replaced with the 32-bit version) an incompatibility with the Database Engine will occur.
To fix these problems the Microsoft Access Database Engine needs to be completely uninstalled and then reinstalled. The instructions below outline the process to follow.
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 version of Microsoft Excel that is installed on your machine. A link to instructions on how to find this information is below.
If you are running Excel 32-bit choose the file called AccessDatabaseEngine.exe
If you are 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
THE CORRECT VERSION OF THE ACCESS DATABASE ENGINE IS 2010. DO NOT DOWNLOAD ANY OTHER VERSION SUCH AS ACCESS DATABASE ENGINE 2016 ETC.
Uninstall the Database Engine¶
Run the Database Engine installation app and select the Uninstall option as shown below. Do not choose the "Reinstall or Repair" option). The Uninstall option needs to be used to fix the problem.
If you encounter a standard Windows error that says [...] is not a valid Win32 application then the file did not download completely and you will need to download the installation application again.
Reinstall the Database Engine¶
After the Database Engine has been uninstalled then run the Database Engine installation app a second time and follow the generic instructions to complete the reinstallation.
If the installation finishes without error, then the Database Engine reinstallation is complete.
However, if the error below occurs when you are installing the Database Engine then an incompatibility between the 32-bit version and the 64-bit version has occurred. This is likely to be the unintended result of Excel 32-bit being uninstalled and replaced with Excel 64-bit on the machine after the 32-bit version of the Microsoft Access Database Engine was first installed.
Before proceeding with the next two steps to fix the error, confirm that you downloaded the correct version of the Database Engine that matches your version of Excel as advised above.
If the correct version was downloaded then you need to force the installation of the Microsoft Access Database Engine to complete. Follow the next two steps to do this.
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.