PRB: Unable to open database file - possible corruption

Document ID: Q101020

This article applies to the following:
Product(s): Second Opinion Professional 3.7
Last Revised On: April 24, 2001

Summary

Second Opinion is unable to open a database table and displays a "CodeBase error -70", "CodeBase error -200", or other.

Discussion

Second Opinion uses a variety of industry standard database tables to store information. Each table consist of a primary data file (.DBF), an index file (.CDX), a memo file (.FPT) and a version control file (.VER). For example the folder data is stored in FOLDER.DBF, FOLDER.CDX, FOLDER.FPT, and FOLDER.VER. Should one of these files become damaged or deleted, Second Opinion will be unable to work properly. You should avoid adding any more data until the problem is resolved.

Possible causes or database corruption

There are several things that can cause database files to become corrupted.

1. If your database is stored on a server and you are running on an Microsoft Network environment and Windows 95, ensure that the VREDIR.VXD file is up-to-date. See Q101007 - PRB: Frequent index corruption under Windows 95 for more information.

2. If your computer crashed while saving information to the database, the database file might not be properly updated and become corrupt.

3. If your database is stored on a server and your network connection or server died, the database file might not be properly updated and become corrupt.

Regardless of the type of corruption, your document files, which are stored separately from the database can still be saved.

1. Make sure Second Opinion is not running from any computer using the database.
2. Run and log into the Second Opinion Administrator program.
3. Click on the Databases tab.
4. Make sure the Location column is referring to files in the correct location.
5. Make sure the Version column contains only numbers and no warnings.
6. Click the Clean Up button. When asked if you wish to re-created the index files to fix possible database corruption problems, click Yes. The program will open each table and attempt to clean it up. If any errors appear, repeat the Clean Up operation a second time. Make note of any messages that appear.
7. Exit the Administrator program. If any problems were reported by the second Clean Up operation, proceed to Step 2, below.

Step 2. Restoring corrupt tables

Unfortunately, if you cannot repair the table (for example, because of a damaged .DBF file header), you must restore it from a backup or, if you do not have a backup, install it from scratch. If you are restoring from a backup, you will loose all information added or modified since the backup was created. If you are restoring from scratch, you may loose all information, depending on which table was corrupt.

Restoring Tables from a backup

1. Make a backup of the existing Second Opinion database directory.
2. Restore the corrupt tables from the most recent backup that was made before the problem occurred.
3. Repeat from Step 1 above. If it still reports errors, revert to a previous backup.

Reinstalling Tables from scratch

NOTE: You will permanently loose information in the tables being replaced.

1. Install Second Opinion Professional on a separate computer that does not currently have the program installed.
2. Enter the minimum required information to complete the installation.
3. Copy the desired tables from the new installation directory to the old Second Opinion directory. For example, if the folder table is damaged, copy FOLDER.DBF, FOLDER.CDX, FOLDER.FPT, and FOLDER.VER from C:\Program Files\Second Opinion\Database in the new computer to C:\Program Files\Second Opinion\Database in the old computer.
4. Repeat Step 1 above (on the old computer) to verify that all tables are now fixed. If necessary copy additional damaged tables from the C:\Program Files\Second Opinion\Database of the new computer to fix additional problems.
5. Finally you may uninstall Second Opinion Professional from the new computer. For safety reasons, you will need to manually delete the C:\Program Files\Second Opinion folder.