>Seems like FoxFix is a very good tool for me to have as the support person. When you mention using SDT in your app, is it automatic or must the user know there is a problem and run the "fix it" routine. Granted them running a fix it routine is better than me running a fix it routine, but is there any tool that will automatically detect and fix some common header or data problems?

SDT can be setup to be semi-automatic and/or with user initiation. SDT can automatically fix a damaged file header if SDT can open the table. If you use SDT OpenTable() method and get a return value of FALSE, you can then call the Repair() method to fix the table then retry with the OpenTable() method. The best way is to create your own open table method that includes these SDT method calls.

FoxFix can be automated like this as well because it comes with a royalty-free runtime library that you can distribute with your apps. However, you will have to create more wrapper code to automate it. SDT already comes with the code [methods].