[AccessD] Another Hosed Database

Dear List:

A client of mine has a database which got corrupted.  I told them to open the back end directly and they got the message which said database appears to be corrupted would you like to attempt repair, which they did and it appeared to go OK.

However, apparently all is not well, because when I try to add a record to a detail file - bound form, subform on a tab - the command DoCmd.GoToRecord ,,acNewRec blows up with 'Can't go to specified record'. 

When I run the query that is the record source for the subform, it does indeed not allow additions.

When I do the same thing on an older copy of their database everything works OK.  So I know it's not in the front end.  

Can this db be saved?

MTIA,

Rocky Smolin
Beach Access Software

P.S. Yes they have a backup but no it's not recent.  Apparently the person responsible for backup up...didn't.