Close the file, duplicate in the Finder.
Try to open the duplicate, if you can SAVE AS both smaller and clone.
Try recover on the clone.
If the recover has no errors, try importing data from the smaller copy.
Sometimes, recovering a copy on another platform works, in your case, Windows.
Backup your database with enthusiasm, after any data entry session, back it up.
Back it up to another drive or flash drive.
Back it up again.
worked like a charm. Thank you so much!
The "accepted" solution here is almost correct
"Recover" is still a last resort, so always try "save as compacted" first. This re-indexes the file "blocks", and can "repair" consistency problems
if that fails, revert to a backup copy, or use Recover
I have collected more info here: