Paradox Database Corruption
Paradox table corruption is an
occasional problem that occurs [usually] when one or more
database table(s) gets large and there is some form of
abnormal termination of the database connection. This is the
nature of Paradox, and, in fact, similar failures occur with all
types of database systems.
OrderGen uses Paradox database tables.
The following sites provide good information about Paradox corruption problems, how to address them, how to prevent them, some of them sell products designed to fix such problems, and
some even offer some form of data retrieval service:
Note: The sites
above are listed as a courtesy for reference only. We do not
necessarily endorse any of the products at these sites; they may
work to fix a corrupted table or index. Any guarantees are those
of the vendor. We are not affiliated with any of these
We try to stress the importance
of regular table maintenance to avoid table and index corruption.
For this purpose, OrderGen includes the following database
maintenance tools, shown in the graphic below.
OrderGen Database Maintenance
for OrderGen databases of all sizes are...
be performed either before or after every session.
rebuild database indexes (once per week).
Clean the tables
the program normally using File | Exit.
cleaning" removes orphaned records that sometimes occur when
a data entry operation is abandoned without completion.
If you have a very
recent backup, you can avoid purchasing and using a separate
utility to try to rebuild your table. The best solution in this case
would be to restore your most recent good backup.
tables ARE NOT covered by basic [free] OrderGen support.
In the case that there
are no recent backups and you don't want to attempt
"do-it-yourself" database repair, you want us to restore
your data in our laboratory. We charge a minimum of 1 billable hour
to attempt to restore as much data as possible, rebuild all indexes,
and pack the table(s).
If your organization
has purchased an annual support contract, there is no additional
charge for this service.
For more information
on support contracts visit the AAS
Support page. Visit OrderGen
Support to ask a question through a free support ticket.
OrderGen and OrderGen
2000 Copyright © 1996 - 2005, Applied
Analytic Systems, Inc.