Repairing Corrupt Paradox Database Tables

Posted on 1998-10-02
Last Modified: 2010-04-06
We keep getting corrupt database headers in our main paradox table - 23mb in size. Is there a way to repair the table? Is there a utility available where we can look at the data (when the header is corrupt, the data cannot be seen) to try and find out why it keeps getting corrupted?
The database is on a Novell server with LAN access. Only used by about 6 users. There are 12 indexes involved. Using Delphi 3.0 Client/Server version.
Question by:CSGPC
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2

Expert Comment

ID: 1341525
I think if you look for a TUTILITY component or program (I think that's the name, it's been a couple of years or so since I've needed it), you might find something that will do what you need.

We had this problem so often with Paradox, it's why we gave it up as a database platform.


Accepted Solution

ZifNab earned 100 total points
ID: 1341526

There are components available (freeware) which can repair the paradox table. You can find functions of the BDE which allow you to repair a table. (I think even RxLib has a repair function)

Here is a link to an example of the usage :

other download versions available at :

Regards, Zif.
LVL 27

Expert Comment

ID: 1341527
I think you should use the Tutilty Utitlity which comes with Paradox.( i.e. by Paradox 7 you find it in the Menu Tools|Tablerepair...
[Live Webinar] The Cloud Skills Gap

As Cloud technologies come of age, business leaders grapple with the impact it has on their team's skills and the gap associated with the use of a cloud platform.

Join experts from 451 Research and Concerto Cloud Services on July 27th where we will examine fact and fiction.


Author Comment

ID: 1341528
I have tried the tutility - but it says that I need to manually re-build the table. How do I do this?

PS I do not have Paradox - we just use Paradox database tables with the Delphit application.

Expert Comment

ID: 1341529
Have you upgraded to version 5.0 of the BDE (available from Inprise's web page)?  I have already found that Version 5.0 is more robust than the  version shipped with D3.  The upgrade was painless for me.

At the same time, you will want to check out the D3 bug fix upgrades on their website.

After you have done these things, try this:

1. make a complete backup copy of your files
2. delete ALL of the index files from the copy you are working on
3. run the TUtility and rebuild all of the affected tables. DO NOT click on the verify button.

If this doesn't work, I think it may mean you're buggered.


Expert Comment

ID: 1341530
P.S. If you are using client server, you may want to move to a SQL server base ASAP.  It is far more reliable and better for large databases.

Expert Comment

ID: 1341531
Correct, large databases are better made on sql server base, not with Paradox. Well, paradox has this problem and sometimes you need to repair it, so why not implementing this repair function into code, so your users can repair the tables themself with a simple button click... Or let the repairing work automatically... Isn't the link I provided you (of example how to repair paradox files) correct?

LVL 27

Expert Comment

ID: 1341532
The freeware in the answer wants the tutil32.dll. This is packed their:

LVL 27

Expert Comment

ID: 1341533
If the freewaretool means to rebuild the table manually then try the rebuild by clicking the rebuild button.


Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month6 days, 21 hours left to enroll

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question