Welcome to SPN

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

Sign Up Now!

Database Keeps Crashing

Discussion in 'Information Technology' started by JOM, Nov 11, 2005.

  1. JOM

    JOM
    Expand Collapse
    Guest

    I have a table that if I try srolling the records across, it keeps crashing
    all the time, I have also tried to compact and repair, it still crashes, I
    imported all my objects into a new table and still when I try to import that
    table, it will crashe and create a backup.... Any particular reason as to
    why this could be happening???
     
  2. Loading...


  3. lingram

    lingram
    Expand Collapse
    Guest

    I've run across similar behavior. Looks like a corrupt record that has
    destroyed an index in the table. If I can identify the suspect record (will
    have unrecognizable data) I create/run a make table query based on the old
    one and load all records <= to the ID of the record before the record at
    fault then all records >= the record ID of the record AFTER the record at
    fault. Don't use the ID of the record at fault. Don't try and sort in the
    table.

    "JOM" wrote:

    > I have a table that if I try srolling the records across, it keeps crashing
    > all the time, I have also tried to compact and repair, it still crashes, I
    > imported all my objects into a new table and still when I try to import that
    > table, it will crashe and create a backup.... Any particular reason as to
    > why this could be happening???
     
  4. Tony Toews

    Tony Toews
    Expand Collapse
    Guest

    JOM <JOM@discussions.microsoft.com> wrote:

    >I have a table that if I try srolling the records across, it keeps crashing
    >all the time, I have also tried to compact and repair, it still crashes, I
    >imported all my objects into a new table and still when I try to import that
    >table, it will crashe and create a backup.... Any particular reason as to
    >why this could be happening???


    To add to Ingram's reply See the Damaged records within tables section
    in the To retrieve your data from a Corrupt Microsoft Access MDB page
    at my website
    http://www.granite.ab.ca/access/corruption/corruptrecords.htm

    Tony
    --
    Tony Toews, Microsoft Access MVP
    Please respond only in the newsgroups so that others can
    read the entire thread of messages.
    Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm
     

Share This Page