Phone Lines icon GFI Support Home

Articles in this section

See more

Creating Reports Using a Rolled-Over MailEssentials Database

Author: Luis Fernandes Updated

Overview

When the GFI MailEssentials reports.mdb reaches the file size of 1.7 GB, the database will be automatically renamed to reports_<date>.mdb and a new reports.mdb will be created. Microsoft recommends that an MDB file should not exceed the file size of 1.7 GB. When this event occurs, the administrator will be notified through a notification email about the location of the renamed MDB file.

This article provides steps a user should follow, should they wish to browse the previous GFI MailEssentials reports.mdb using the GFI MailEssentials Reports. 

Process

Follow the instructions provided below:

  1. Install GFI MailEssentials on a separate machine. This installation will only be used to browse the previous (renamed) GFI MailEssentials reporting database.

  2. Copy the previous (renamed) GFI MailEssentials reports.mdb database from the existing GFI MailEssentials server to the new GFI MailEssentials server.

  3. Once the transfer is complete, open the GFI MailEssentials configuration.

  4. Expand the Reporting > Settings.

  5. Ensure that Microsoft Access is selected as the database type (option not available after GFI MailEssentials 2014 R2).

  6. Copy the directory path from Step 2 into the file location and click Apply to save the settings.

  7. View the contents of the reporting database from the GFI MailEssentials Reports.

Notes:

  • As a proactive step to avoid the renaming of the reports.mdb database, one can compress the GFI MailEssentials reports.mdb before it reaches the 1.7 GB limit. 

  • Starting with GFI MailEssentials 2014 R2., Microsoft Access databases will no longer be offered as an option. Instead, Firebird database or Microsoft SQL database can be configured for GFI MailEssentials Reporter.

  • Firebird databases do not have a limitation of 1.7 GB file size.

Related articles