Hi Don,

Is it possible that this is not a file corruption issue, but an index issue? If so, rather than removing records, you would make a clone of your solution and import your (good) data.

The following link has more information.

http://fmdiff.com/fm/recordindex.html
-- 
Jonathan Gottlieb
Database Developer
Island Technologies
[log in to unmask]

On Sep 28, 2010, at 12:18 PM, Don Wieland wrote:

> Sigh...
> 
> I have a client's solution in where in two table there is a one record that I believe is corrupted:
> 
> - I have a specific relationship where the record relates to it even when the key fields to the records DO NOT match.
> 
> - When I delete it, it disappears, but when I do a search on it again, it shows up with "?"'s in all the fields and the found set says 0/1 records displayed.
> 
> I have my own plan of trying to get rid of these records, BUT was hoping that some one might share with me some quicker (or at least more efficient) way to handle these corrupted DBs.
> 
> I'd appreciate any thoughts or recommendations on this. I have to deal with this issue this week and could use some insights. Thanks ;-)
> 
> Don Wieland
> D W   D a t a   C o n c e p t s
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> [log in to unmask]
> Direct Line - (949) 336-4828
> 
> Integrated data solutions to fit your business needs.