Error upgrading: "SQLite3_statement_backend:loadOne UNIQUE constraint failed: Sessiondetals.ID" (4225837)

When upgrading from 8.7 or earlier, to 8.7.1 or later, the upgrade of the mdb files may fail with the following error:

"SQLite3_statement_backend:loadOne UNIQUE constraint failed: Sessiondetals.ID"

Duplicates in the SessionDetails table of the ERDiskAD.mdb file

Use Microsoft Access to open the file, check for duplicates and if found, delete the duplicates:

1. Make a backup of the ERDiskAD.mdb file
2. Open the ERDiskAD.mdb file using Microsoft Access
3. Click Create | Query Wizard
4. Select Find duplicates query wizard and click Next
5. Select Table: SessionDetails from the list and click Next
6. Select ID, click the arrow button and then click Next
7. Click the double arrow button and click Next
8. Click Finish
9. For each duplicate, right click one of the duplicate rows and select Delete Record
10. Click File | Save
11. Try the upgrade again