In continuation of last weeks post:- I found a utility called DTutil32.exe - can't remember where it came from - witten by Frolich & Panchero. It's essentially a wrapper for TUtil32. This utility works fine on my machine, but complains of missing DLL files on my client's system. Is there a way to find out (at my end) which dll's this utility is going to require so that I can include these with it? Thanks Mark [EMAIL PROTECTED] wrote: > 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
begin:vcard n:Howard;Mark tel;cell:(021) 477 564 tel;fax:(07) 348 8178 tel;work:(07) 348 8177 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Forest Production Systems Ltd end:vcard