Solved

Repairing Corrupt Paradox Database Tables

Posted on 1998-10-02
9
503 Views
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.
0
Comment
Question by:CSGPC
  • 3
  • 2
  • 2
  • +2
9 Comments
 

Expert Comment

by:gdebiasa
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.

Glen
0
 
LVL 8

Accepted Solution

by:
ZifNab earned 100 total points
ID: 1341526
Hi CSGPC,

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 :
http://www.inprise.com/devsupport/bde/files/tutil32d.zip

other download versions available at :

http://www.inprise.com/devsupport/bde/delphifiles.html

Regards, Zif.
0
 
LVL 27

Expert Comment

by:kretzschmar
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...
0
 

Author Comment

by:CSGPC
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.
0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 

Expert Comment

by:dejohn99
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.


0
 

Expert Comment

by:dejohn99
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.
0
 
LVL 8

Expert Comment

by:ZifNab
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?

Zif.
0
 
LVL 27

Expert Comment

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

http://www.inprise.com/devsupport/bde/files/tutil40.zip

meikl
0
 
LVL 27

Expert Comment

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

meikl
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
APK file name 7 64
loading dll from external path 1 198
delphi custom sort exception 6 111
Delphi IDE crash without error message ... 7 60
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now