Corruption

  • Thread starter Thread starter David S
  • Start date Start date
D

David S

Hello,
I'm in a tight spot and I hope you can help. My client's
table has a last record that reads #Deleted all accross
the last line. The file is still operating but is going
to die. Here is what I have tried to recover,

Exporting to another format
Compact repair
JetComp
Append query
Make table query
copy table

Nothing has worked to get a normal file. I'd really
appreciate any ideas you may have. Thanks.

David
 
How about DAO code to step through that table to the record just before the
corrupted one, writing each to a new table. Then delete the table with the
corrupted record.

I'd think you should be able to do the same with an Append Query provided
you used Criteria that limited it to only the good records, but that may be
what you have tried already.

You could also contact Peter Miller, http://www.pksolutions.com, who has an
excellent reputation for recovering data from corrupted databases. He even
will look over your database and give you a free estimate on the cost of
recovery.

Larry Linson
Microsoft Access MVP


Larry Linson
Microsoft Access MVP
 
Hello Larry,
Thanks for your insight. The query option didn't work. I wrote some test
code to step through each record and save it to another table. That worked.
That is the first break I got after 3 hours of work.

Thanks for Peter's information. It is nice to have a back-up plan if all
else fails.

David.
 
"David S." wrote
Thanks for your insight. ...
Thanks for Peter's information.
Click to expand...

You are most welcome, David. I'm glad you got past the stumbling block.

Larry Linson
Microsoft Access MVP
 
Back
Top