>>>I notice there are several tools out there to fix corrupted tables. Anybody have any suggestions as to which one works best in VFP 5.0? Do any of them fix a corrupted database in VFP 5.0? Are any of them written in code that we can run from within our application, allowing us to automatically fix the tables without any user interaction? Any help would be appreciated. Thanks
>>>
>>>GeneS
>>
>>I use Stonefields DB Toolkit. It has a function that you can write into your app for a dba to use after a system crash that checks and repairs all tables in the DB. Pretty slick.
>>
>>Erik
>
>
>hi Erik..
>Where can I find the Stonefields DB Toolkit?..thanks ..rob


You can find Stonefield at www.stonefield.com. They have an excellent tool for managing and fixing dbfs. One of the key reasons I use the toolkit is for the features it provides when modifying a table structure. If your users have an existing table that needs a new field or a structure change, it can be very difficult to update automatically in VFP5. This is especially so when you have extended information stored in the database container. With the toolkit, all you need to provide your users with is a new copy of the DBC and the stonefield dbfs that store some metadata information. By running an update utility it will automatically recreate the table with the new structure without losing any information.

Bob