Quoting Mark Howard <[EMAIL PROTECTED]>:
> Hi
>
> My users have had the occaisional problem with Paradox table and
> or index corruption - normally caused by a power outage or
> someone running a backup with the databse open.
>
> In the past I have been able to fix things most of the time by
> deleting the index files and then redefining the primary and
> secondary index's, using the DBD.
>
> This hasn't always worked - and hasn't in the current case. What
> is the best way of dealing with this problem?
Basically you have 3 options:
1. Buy a commercial product like TV which is done by Wade A. From memory it's
about $300.
2. Use the freebie table repair utility on Borland's web site.
3. Develop your own, preferably using components like the TTUtility component
set from Out & About www.o2a.com
It may still be of course that the problem that your client has had can't be
repaired - and that is when backups are important.
>
> Also, on a similar topic, would it be good, bad or indifferent
> practice to programatically delete and rebuild the index's each
> time the application opens, to keep them clean. (Or is that a
> dumb question?)
I believe some people here do it, like Russell Belding.
> Can you repack tables programatically? How?
You can use the TTutility components to do all sorts of things.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
