How to restore an ExcelReportLink database from a backup

From ExcelReportLink Wiki
Jump to navigation Jump to search

Overview

ExcelReportLink stores Settings in an Access database named AddonsLink Workspace.mdb which is located in the \ExcelReportlink [Edition]\Workspaces\[Your Workspace] folder.

ExcelReportLink will prompt to take backups of this database upon closing or before advanced processing. Backups are stored in the \ExcelReportLink\Workspaces\[Your Workspace]\Backup\ folder. If the ExcelReportLink Database becomes corrupt, it can be restored from a back up.

This article describes how to do that.

Procedure

  1. Close ExcelReportLink;
  2. Open Windows Explorer and browse to the \ExcelReportlink [Edition]\Workspaces\[Your Workspace] folder;
  3. Locate the AddonsLink Workspace.mdb;
  4. Move the AddonsLink Workspace.mdb file \ExcelReportlink [Edition]\Workspaces\Backup\ folder. Rename with a date time stamp if a file with the same name already exists;
  5. Browse to the \ExcelReportlink [Edition]\Workspaces\;
  6. Browse to a Date Time stamp folder when ExcelReportLink was working;
  7. Copy the AddonsLink Workspace.mdb file and paste into the \ExcelReportlink [Edition]\Workspaces\[Your Workspace] Folder;
  8. Restart ExcelReportLink;
  9. Run a Full Get Data.

Notes

  • The Backups are prefixed with a date time stamp which is taken from the date when the backup was taken and formatted as yymmdd - hhmm. This date time stamp must be removed when restoring the backup.

Related Links

Retrieved from "https://accountingaddons.com.au/wiki/excelreportlink/index.php?title=How_to_restore_an_ExcelReportLink_database_from_a_backup&oldid=1684"