[comp.databases] Paradox - problems with corrupted files

ldan@neon.Stanford.EDU (Daniel Asher Lichstein) (05/17/91)

	I have been having problems supporting a Paradox application in which
some files are randomly corrupted about once every 3 or 4 months.  When this
occurs my current recourse is to use TUTILITY, rebuild the indexes, copy
over the appropriate forms and reports (because they will be corrupted), and
then hope everything works.  Finding out the problem requires a good guess
and then using TUTILITY.  
	Is there an application out there that will identify corrupted files,
fix them while retaining the indexing, forms and reports??  I would be willing
to pay handsomly for such a program.  Is this a problem other people are 

byock@umaxc.weeg.uiowa.edu (Bill Yock) (05/22/91)

From article <1991May16.173547.9558@neon.Stanford.EDU>, by ldan@neon.Stanford.EDU (Daniel Asher Lichstein):
> 
> 	I have been having problems supporting a Paradox application in which
> some files are randomly corrupted about once every 3 or 4 months.  When this
> occurs my current recourse is to use TUTILITY, rebuild the indexes, copy
> over the appropriate forms and reports (because they will be corrupted), and
> then hope everything works.  Finding out the problem requires a good guess
> and then using TUTILITY.  
> 	Is there an application out there that will identify corrupted files,
> fix them while retaining the indexing, forms and reports??  I would be willing
> to pay handsomly for such a program.  Is this a problem other people are 

The main cause of table corruption in Paradox seems to be power failures.  Do
you have a reliable power supply?  The only other program that I know of that
fixes damaged tables is ParaFix from TSR Systems (516) 331-6336.  I'm not sure
it can detect corruption and fix all related objects.  You could write a PAL
routine that reconstructs objects automatically.  Setup a table that stores
a tables structure, it's indexes, reports and forms definitions and use it
to help reconstruct things.

--
Bill Yock, Weeg Computing Center, University of Iowa, Iowa City, Iowa 52242
byock@umaxc.weeg.uiowa.edu