[AccessD] Another Hosed Database

I've used that with some success as well.  Especially where a form is
corrupted.  But in this particular case, it failed.

Rocky

----- Original Message ----- 
From: "Elam, Debbie" <DElam at jenkens.com>
To: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Tuesday, November 11, 2003 6:51 AM
Subject: RE: [AccessD] Another Hosed Database


> There is my tried and true of dumping all of the database into a new blank
> database.  That has fixed quite a lot of messed up databases for me.
>
> Debbie
>
> -----Original Message-----
> From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com]
> Sent: Monday, November 10, 2003 1:50 PM
> 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
> - JENKENS & GILCHRIST E-MAIL NOTICE - This transmission may be: (1)
subject
> to the Attorney-Client Privilege, (2) an attorney work product, or (3)
> strictly confidential. If you are not the intended recipient of this
> message, you may not disclose, print, copy or disseminate this
information.
> If you have received this in error, please reply and notify the sender
> (only) and delete the message. Unauthorized interception of this e-mail is
a
> violation of federal criminal law.
> This communication does not reflect an intention by the sender or the
> sender's client or principal to conduct a transaction or make any
agreement
> by electronic means.  Nothing contained in this message or in any
attachment
> shall satisfy the requirements for a writing, and nothing contained herein
> shall constitute a contract or electronic signature under the Electronic
> Signatures in Global and National Commerce Act, any version of the Uniform
> Electronic Transactions Act or any other statute governing electronic
> transactions.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>