corrupt record

  • Thread starter Thread starter Jacquie
  • Start date Start date
J

Jacquie

Through lots of trial and error, I found out that there is
one record in a table that is corrupt: MORS-FRAN. But
every time I even view it in Access, Access shuts down. If
I try to export the table to Excel, it shuts down. I've
tried to open it in Excel, it shuts down. What I have to
do is somehow get into that table not through Access and
get rid of that one record, but I can't figure out how.
Any ideas? Thanks!!
 
Jacquie said:
Through lots of trial and error, I found out that there is
one record in a table that is corrupt
Click to expand...

Good work. It's rather frustrating though.

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
 
Through lots of trial and error, I found out that there is
one record in a table that is corrupt: MORS-FRAN. But
every time I even view it in Access, Access shuts down. If
I try to export the table to Excel, it shuts down. I've
tried to open it in Excel, it shuts down. What I have to
do is somehow get into that table not through Access and
get rid of that one record, but I can't figure out how.
Any ideas? Thanks!!
Click to expand...

This is doable albeit quite tedious. :-{(

Your database is corrupted and cannot be repaired. Create a brand-new
empty database and use File... Get External Data... Import to import
everything BUT this table. Import this table using the "design mode
only" option.

Now use File... Get External Data... Link to link to this table and
create one or more Append queries to import all the records *except*
this damaged record. If you use ranges on the table's Primary Key
field it will use the Primary Key index to select the records, and
will not need to open the table records themselves (which would just
cause the error crash again).

The damaged record will need to be reentered manually.
 
Back
Top