Answer
If you encounter an unexpected error when opening Lightning Payroll, it might be due to a corrupt database. Common reasons for database corruption include unexpected software shutdowns, system crashes, or hardware failures that interrupt database writing processes.
Lightning Payroll automatically creates backups at crucial moments such as software closure, backup restoration, or during software upgrades. These backups are your safety net in case of database issues.
To address a database error:
- First, download and run the Database Recovery Tool from here.
- Upon launching the tool, you'll see a list of all available backups stored locally on your computer. These can be found at
C:\Users\{User}\AppData\Roaming\Lightning Payroll\auto_backup
. - The backups are displayed from the newest to the oldest. Select the backup you wish to restore by clicking on it.
- Click Yes to confirm your choice. Be mindful of the file size indicated next to each backup. A significantly smaller file size compared to others might indicate a corrupted database.
This utility will help you restore your data to a point before the corruption occurred, allowing you to resume work without losing critical payroll information.