[AccessD] Another Hosed Database

Rocky,

You've GOT to get some different clients! LOL

What version of Access and have you tried building a new query?

Charlotte Foust

-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Monday, November 10, 2003 11:50 AM
To: AccessD at databaseadvisors.com
Subject: [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.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com