Hi Brenda.

>It seems that FoxFix and Stonefield are the two most popular tools. Anyone know the differences between them? I am not interested, i think, in the data dictionary aspect of Stonefield, just the data recovery and repair.

FoxFix and Recover are better tools than SDT for a programmer's toolbox when it comes to data repair. The reason is because SDT only does header (table and memo) repair, not data area repair, which the other tools do. In my experience, the vast majority of the time that a table needs repairing, at least in a runtime environment, the problem is due to header damage. SDT can handle that automatically, which makes it work well in a runtime environment. For those few times when the data area is damaged, FoxFix and Recover are indispensible. They really are programmer's tools (you wouldn't want to put them into an end-user's hands) but when you need them, you really need them.

SDT can do a lot of other things for you, like update table structures at remote sites, repair corrupted indexes, and redefine views when table structures change, so I don't think it's an "either-or" purchase decision.

Doug