[AccessD] Another Hosed Database

Rocky, can you compact the db? Maybe it has corrupted records. Usually if its bad enough, you will get an error massage stating "you and another user are attempting to view the same record..." and leave you with an uncompacted mdb and a new db1.mdb. Maybe they got that message and didn't tell you when they repaired the mdb?

David

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
Beach Access Software
Sent: Monday, November 10, 2003 12:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com