IT SOLUTIONS
Your TECHNOLOGY partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► KBDesktop Data...Paradox & Ob...Paradox Tables    
Go To Random Article
  From the August 2011 Issue of Prestwood eMag
 
Repair Paradox Tables
 
Posted 5 years ago on 6/5/2008 and updated 4/11/2010
Take Away:

Step by step instructions for repairing your Paradox tables.



More Info

KB Post:  BDE Best Practices: Safely Use Paradox Tables
FAQ:  Copy Paradox Tables with Confidence

Linked Message Board Threads

 px file gets dropped when rebuilding in Paradox Tables MB Topic (3 replies)
 Files required to run tutil32.fdl in Paradox Forms MB Topic (7 replies)
 Paradox Table Repair Verify Option in Paradox Tables MB Topic (5 replies)
 Table Repair in Paradox Tables MB Topic (2 replies)
 Table Repair failure in Paradox 8 (and Paradox 9) in Paradox Tables MB Topic (8 replies)
 Table Repair in Version 10 in Paradox Tables MB Topic (0 replies)
 table Repair in Paradox Tables MB Topic (3 replies)

Comments

1 Comments.
Share a thought or comment...

vinylsol
Comment 1 of 1

I occasionally have to repair a table - I usually notice this requirement when trying to change the default field data; restructure won't work until the table has been repaired. However after my recent experience I would like to recommend that before rebuilding a table, you should backup the corrupted table - obviously to a different location to your normal backups - because if the rebuild fails it is possible to do even more damage.

Usually when I repair a table I just let Paradox rumble happily away until it is finished but yesterday when I started a repair, I opened a new window and began working with another program. In the past, I have always left the Paradox screen open until the repair had finished but when I returned to Paradox this time  I discovered that the program had hung. I used Task Manager to end it, then reloaded Paradox to discover that all my filters had disappeared, my default fields were all empty and four records out of 120,000 had  vanished completely. Presumably, these were the records Paradox was actually working on when the program hung.

Fortunately, the table was backed up immediately before the repair and after copying it back and starting the repair again everything worked perfectly. But because of this I would heartily recommend:

1) Backup the table immediately prior to the repair.

2) Don't run anything else while Paradox is repairing.

I'm using Paradox 10 under Vista.

Posted 5 years ago
 
Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post:

Enter your name and security key.

Your Name:
Today's security key = P183A
Enter key:
Article Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.



Linked Certification Question(s)

The following are practice certification questions with answers highlighted. These questions were prepared by Mike Prestwood and are intended to stress an important aspect of this KB post. All our practice questions are intended to prepare you generally for passing any certification test as well as prepare you for professional work.

Intermediate

1 Intermediate Level Question

Question #1: True or False?

Table Repair (a.k.a. TUtility) has both verify and rebuild options. It is sufficient to verify a table. If the table passes verification, there is no need to rebuild the table.

Answer:
  • True
  • False

  •  KB Article #101167 Counter
    11953
    Since 6/5/2008
    -
      Load Time=less than 1 second.
     
    Print This

    KB Post Options:
    -
     
    Have a question? Need our services? Contact us now.
    --Mike Prestwood

    Call: 916-726-5675

    email: info@prestwood.com


    -
     
    Connect With Us...
    PrestwoodBoards
    Join Us!
    Facebook
    Like our page!
    Twitter
    Follow us!
    LinkedIn
    Join Group
    YouTube
    View channel.
    Go ahead!   Use Us! Call: 916-726-5675 


    ©1995-2013 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.