You have multiple solutions to fix this situation.1.
You can use Jet Compact utility (JETCOMP.exe)
. This will repair the file if corruption is the main problem behind missing records. You can learn more about Jet Compact utility here
You can also try Compact and Repair
You can try to open the database file in OpenOffice.org Base
If all these solutions fail, then you can try third-party MS Recovery
software. You must try its demo version before buying any other software. It will recover your all missing records and saves them to a new database file.
Hope this will help you. Good luck.