Database Keeps Crashing

[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???

 

[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.

 

[Tony Toews]

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