[AccessD] Another Hosed Database

Charlotte:

Hey - this is the kind of client that pays the rent.  Anyway, it's not in
the query (which is in the front end) because when I restore an older copy
of their BE db the FE works just fine.

Since my first post I have determined that there is a parent record
(agreement header) missing in the header table which has 4 child records
(agreement details) in the detail table.  FK in those child records points
to a non-existent PK in the parent table).

So I think the repair didn't.  But on the surface, the orphan child records
alone should not product the result they're getting.  OTOH, it points to
other possible problems in the BE.

Rocky

----- Original Message ----- 
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, November 10, 2003 12:02 PM
Subject: RE: [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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>