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 [email protected] 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~ > [email protected] > Direct Line - (949) 336-4828 > > Integrated data solutions to fit your business needs.
