NAPIS® 'Step-by-Step' for Paradox Table Repair

The Borland Paradox Table Repair utility program verifies table and index information and can be used to rebuild corrupt tables.

If you see an error on the NAPIS Lite splash screen similar to the one below (where the \TABLE_NAME.DB may be different), Paradox Table Repair can help you diagnose and repair the cause of the corruption.

Error To the top

Step 1. Before you begin, backup your data.

Step 2. Open the Paradox Table Repair Utility:

In Windows Explorer navigate to the 'c:\Program Files\Napis Lite\Utilities' directory and double-click the 'Pdx_Table_Repair.exe' application. The program will open as shown.

Borland TUtility To the top

Step 3. Set the Alias Name and the Table Name:

In the 'Select Table Directory and File' group, click the down arrow to the right of the Alias Name field and select 'NAPIS_DATA'. Use the pull-down list by the Table Name field to select the name of the table that you want to verify and/or rebuild (the graphics in this Step-by-Step represent the table that was shown in the error message above).

Borland TUtility To the top

Step 4. Verify the Table Information:

Click the 'Verify' button. The utility will evaluate the table and check the Header, Indexes, and Data.

When the process is complete, a message will appear at the bottom of the form stating 'Verification Successful. etc'. Do not assume that because you read the word 'Successful' everything is okay with the table. Skip Step 5 if, and only if, the message reads 'Verification Successful. Table has no errors.'

In this example, the message reads 'Verification Successful. Verification could not be completed.' Another message that indicates corrupted tables is: 'Verification Successful. Verification completed.' In either case, proceed to Step 5.

Borland TUtility To the top

Step 5. Rebuild the Table Information:

Since the table has been corrupted, you should now attempt to rebuild it. Click the 'Rebuild' button on the body of the form. When the process is complete a message should appear at the bottom of the form stating 'Rebuild was successful'.

If the message reads 'Rebuild was not successful', go to the 'c:\Program Files\Napis Lite\Utilities' directory and refresh the view (View | Refresh). Delete all files named 'Backup.*' (DO NOT delete files by any other name). Go back to the Paradox Table Repair Utility and click 'Rebuild' again.

If the message still reads 'Rebuild was not successful', contact White Point Systems for assistance. Otherwise, proceed to Step 6.

Borland TUtility To the top

Step 6. Verify all other tables in the database:

Although the initial error message shown in the introduction to this 'Step-by-Step' listed only one table, other tables in the database may also be corrupted. You should repeat Step 4 (and, if necessary, Step 5) for every table in the database. Use the list below to check off the NAPIS Lite Table Names and add any relevant notes as you proceed through them.

Table Name Notes
COMPANY.DB
DEPARTMENT.DB
HERBARIUM_LABEL.DB
INTERMED_RECORD.DB
INVESTIGATOR.DB
N_COLLECT_COMMON.DB
N_COLLECT_MARINE.DB
N_COLLECT_PLANT.DB
N_COLLECTOR.DB
N_IMAGE.DB
N_MICRO_SOURCE.DB
N_MICRO_SOURCE_O.DB
N_OTHER_TAX.DB
N_SAMPLE_COMMON.DB
NCI_MEDUSE.DB
NCI_OTHER_NAME.DB
NEXTNUM.DB
OTHER_SITE_COLLECTOR.DB
PERSON.DB
PERSONS_IN_COMPANY.DB
PROTOCOLS.DB
SITE_COMMON.DB
SITE_MARINE.DB
SUBMIT.DB
VOUCHER.DB
WORK_ORDER.DB
WORK_ORDER_DETAIL.DB
Z_USERS.DB

Step 7. Confirm that corruption has been cleared:

Reopen NAPIS Lite. If the error message still appears after you have completed Step 6, contact White Point Systems. Otherwise, proceed with data entry.