Unable to open search databases / Error saving Search Wizard

Issue

This issue presents itself in several ways, all relating to database issues loading or saving searches.

Unable to open search database

When opening an exiting project, or after creating a new search, the following error appears for each search in that project 'ERROR: Unable to open search database for [GUID]”

In the Application Log, the following is noted:

[13:17:21.9 Jul-19] PDB: ERROR: Unable to find the Discovery Attender database: C:\Projects\Test Indexes\Searches\19553301-32A5-4A65-812D-F386BABFDD4F\Database\DA.accdb

Error Saving a Search Wizard

• When saving a search at the end of the Search Wizard, user gets an error pop-up with the text:

Unable to Save Search Wizard:
Unable to save search to database. See log file for details.

In the Application Log (see image above), the following is noted:

ERROR: Unable to connect to database [GUID] Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Cause

These issues are caused when multiple versions of Outlook were installed/uninstalled on a machine, particularly when upgrading to more recent versions. It has also been seen on brand new machines where the required .dll may not be installed by default. This affects the ability of Discovery Attender to communicate with the file-based Access databases.

Resolution

1. Close Discovery Attender and all Office products, including Outlook.
   Note: Using Task Manager can help ensure no Office/Outlook processes are running in the background.

2. Uninstall the Microsoft Office Access Database Engine 2007 if it is present.

3. On the server where Discovery Attender is installed, download the Microsoft Access Database Engine 2010 Redistributable file:

   1. Access 2010 Redistributables (Gimmal Website)
      Note:

      1. Be sure to download the correct 32-bit or 64-bit version. The bitness of the executable must match the bitness of your installed Discovery Attender/Outlook version.

      2. Please contact support@gimmal.com if you are unable to access the download directory linked above

4. Run the executable, agreeing to all the prompts.

5. Restart Discovery Attender and test a new search.