Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Corrupt Table/Records, unable to open, export, or copy...

Discussion in 'Information Technology' started by Bassthumpa, Jul 28, 2006.

  1. Bassthumpa

    Bassthumpa
    Expand Collapse
    Guest

    I need help once again...

    I have a database that has one main table for most of it's data. For
    some reason, it looks like two of the records have been corrupted...
    because of these recoreds, the table cannot be opened in Datasheet view
    (get an "invalid argument" error before it fails to open), and any
    attempt to repair the database or copy the table results in the entire
    Access session to crash and an error report to be sent. Attempt to
    export the table have the same result.

    I should also mention that the table MSysCompactError comes up, showing
    entries with error codes 1003, 1017, and 1053. Each entry notes has
    the "Could not find field 'Description'." in the description field.
    The table that I'm working with does not have a field by that name. I
    presume these errors are from my attempts to compart and repair.

    I have a form that view individual records, and when I scroll through
    those records there are only two that cause the form to hose up with
    strange characters and Invalid Data (#error) notices. I'm thinking
    that if I can find a way to kill those two records, I may be able to
    salvage the rest of the data. How would I go about doing this without
    opening the forms or table?
     
  2. Loading...

    Similar Threads Forum Date
    Politics Power Corrupts but It Also Plays with Your Mind Breaking News Sep 22, 2013
    India Corruption rate in India is double of global average Breaking News Jul 9, 2013
    Partition Corruption in the Punjab... History of Sikhism Mar 24, 2013
    Bant Singh - A real anti-corruption hero Inspirational Stories Feb 27, 2013
    India US report slams India on corruption, social violence Breaking News May 25, 2012

  3. Bassthumpa

    Bassthumpa
    Expand Collapse
    Guest

    I should also mention that I have the record numbers for the two
    records that seem to be hosing everything up... I'm not sure if I could
    somehow reference those record numbers using some sort of form/code to
    have it delete those specific records.
     
  4. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    At times like this, nothing beats a good backup.

    Tony Toews has an excellent web page on database corruption.
    http://www.granite.ab.ca/access/corruptmdbs.htm

    Allen Brown also has excellent info on corruption.
    http://allenbrowne.com/ser-47.html

    I have a white paper in a Word document named Fix Corrupt Access Database
    towards the bottom this page:
    http://www.rogersaccesslibrary.com/OtherLibraries.asp
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


    "Bassthumpa" wrote:

    > I need help once again...
    >
    > I have a database that has one main table for most of it's data. For
    > some reason, it looks like two of the records have been corrupted...
    > because of these recoreds, the table cannot be opened in Datasheet view
    > (get an "invalid argument" error before it fails to open), and any
    > attempt to repair the database or copy the table results in the entire
    > Access session to crash and an error report to be sent. Attempt to
    > export the table have the same result.
    >
    > I should also mention that the table MSysCompactError comes up, showing
    > entries with error codes 1003, 1017, and 1053. Each entry notes has
    > the "Could not find field 'Description'." in the description field.
    > The table that I'm working with does not have a field by that name. I
    > presume these errors are from my attempts to compart and repair.
    >
    > I have a form that view individual records, and when I scroll through
    > those records there are only two that cause the form to hose up with
    > strange characters and Invalid Data (#error) notices. I'm thinking
    > that if I can find a way to kill those two records, I may be able to
    > salvage the rest of the data. How would I go about doing this without
    > opening the forms or table?
    >
    >
     
  5. Bassthumpa

    Bassthumpa
    Expand Collapse
    Guest

    Fortunately for me, I did a backup at the beginning of the month, and
    didn't even remember doing it. WHEW! I should be able to use my
    working form to save the rest of the records except the two corrupt
    ones.

    I'm still wondering what caused the table to bork itself in the first
    place. I'll dig into those links and try to learn a few things to
    prevent it from happening again.
     
  6. Bassthumpa

    Bassthumpa
    Expand Collapse
    Guest

    Blast... won't be that simple, as the sort order of the tables was
    changed somehow. Well, at least it'll be working for the most part
    again.
     
  7. Bassthumpa

    Bassthumpa
    Expand Collapse
    Guest

    Ok, I created a new database and linked to the tables of my old one.
    It was able ot open the data table, but not able to delete the borked
    records... so I just created a new table, copied all of the records
    except for the two bad ones, delete the bad, rename the good, and I'm
    back in action!
     

Share This Page