Optimization error

[DavidCrow]

Note: This post only applies to the Legacy database!

I was getting AW ready for the upcoming year.  After verifying primary key autoinc values of the core tables, I get the attached error.  I dismiss the error dialog and optimization continues.  After (or it might be during) checking for orphaned records, it pops up again.  The Database Utilities: Optimization dialog stays open at this point and the Cancel button does nothing.  I have to click the X.

[Rick Leffler]

Any time you see the word "corrupt" in an error message, please run the REPAIR utility under Admin > Database Utilities.  After the Repair is complete, exit and restart the database.  USUALLY this will fix the problem, however if it does not, depending on the file it may be necessary to restore your last backup.

[DavidCrow]

Repair fixed it.  Thanks Rick.