Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!usc!wuarchive!uunet!ns-mx!umaxc.weeg.uiowa.edu
From: byock@umaxc.weeg.uiowa.edu (Bill Yock)
Newsgroups: comp.databases
Subject: Re: Paradox - problems with corrupted files
Message-ID: <6156@ns-mx.uiowa.edu>
Date: 21 May 91 18:38:04 GMT
References: <1991May16.173547.9558@neon.Stanford.EDU>
Sender: news@ns-mx.uiowa.edu
Lines: 23

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