Re: Corrupted Record

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 12/03/04 

Date: Fri, 03 Dec 2004 14:45:16 -0700

On Fri, 3 Dec 2004 09:27:10 -0800, Gee...
<Gee@discussions.microsoft.com> wrote:

>I have a record that suddenly changed all the dates to 12:00am and most of
>the entries into what looks like Japanese. The unique ID should be 154, but
>instead it's turned into "-1577058149". I tried to delete the record and
>re-enter, but when I highlight and ask it to delete (from the table) is says
>"The search key was not found in any record." and won't let me.
>How do I get rid of this record?
>Thank you in advance for your help.
>Gee...

You'll probably need to take some serious action to fix this. See Tony
Toews' Corruption FAQ at

http://www.granite.ab.ca/access/corruptmdbs.htm

I'd suggest creating a new, empty .mdb file; import everything *but*
this table; import this table *design mode only*. Then link to it and
run an Append query appending only the non-corrupted records (use a
criterion on the Primary Key field so it uses only the Index, not a
table scan) to append the good data. This record is toast and will
need to be manually reentered; any records which were related to it
will need to be checked.

                  John W. Vinson[MVP]
             Join the online Access Chats
        Tuesday 11am EDT - Thursday 3:30pm EDT
      http://community.compuserve.com/msdevapps

Relevant Pages

  • Grid Highlight when Custom Color in Cell Problem
    ... More than one column may have colored cells. ... then the highlight color should not override it ... APPEND BLANK ... ENDPROC ...
    (microsoft.public.fox.programmer.exchange)
  • getting rid of warning dialog
    ... database. ... there is an annoying warning dialog that pops up, and I'd like to get rid of ... You are about to append 1 row.Once you click Yes, ... How can I get rid of this? ...
    (microsoft.public.access.gettingstarted)
  • Re: copying a 2 CD set
    ... After ripping the tracks off CD, ... Highlight all the ... tracks right click and bring up the advanced Tag Editor. ... Then append to the ...
    (microsoft.public.windowsmedia.player)
  • Re: Visual Basic - Create Table
    ... prompt me "No fields defined, can't append Table or Index. ... highlight to me what is the problem. ... John W. Vinson ...
    (microsoft.public.access.queries)
  • RE: Appending to a data record
    ... The Trim() function gets rid of any leading or trailing spaces. ... So is it possible and do I use an append query to do it? ...
    (microsoft.public.access.queries)