|
"Error Number 3343: Unrecognized database format kform.mdb" |
|
|
|
|
The error message is typically generated when the Jet database engine was improperly shut down during the process of writing to disk and the database has become corrupted. To repair the database, the compact and repair utility needs to run. The compact and repair utility can be performed using MS Access or from Kform Project Manager’s program menu. The Compact utility gets rid of empty space in an existing database. The Repair utility tries to repair only the tables, the queries, and the indexes in the database. The Repair utility does not try to repair damaged forms, reports, macros, or modules. Compacting and repairing the kform.mdb using MS Access: - If the database is open, close it.
- On the Tools menu, select Database Utilities and then select the Compact and Repair option.
- In the Compact Database From dialog box, select kform.mdb. The default installation is C:\Program Files\Kform Incorporated\Kform Project Manager.
- In the Compact Database Into dialog box, enter a new file name and then click Save. The default file name is db1. Using Windows Explorer navigate to the install directory. Rename the original (corrupt) kform.mdb to kform.old.mdb then rename the repaired database (default name db1) to kform.mdb.
- Kform Project Manager should now open normally.
- If the compact and repair does not succeed, you will receive a message. This means the damage to the database is severe enough that it could not be repaired. In this case, the most recent back-up of the database should be utilized to overwrite the corrupt one.
Compacting and Repairing Using Kform Project Manager: Kform Project Manager contains the same compact and repair utility as MS Access. The utility can be accessed from the Windows Start Menu and also from Kform Project Manager Utility Menu. Using either selection automatically renames the corrupt database to kformold and names the repaired database to kform.mdb during running of the utility.
Running Compact Database from the Windows Start Menu: To run Compact Database from the Windows Start Menu Programs selection, click on Kform Project Manager Server. From the Kform Project Manager Server Menu select Compact and Repair Database. From the Options menu select Compact. The following message appears on the Compact Database screen: "As the users change data, the database file can become fragmented and use more disk space than is necessary. Run this Compact Database option periodically to compact your database to defragment the database file. The compacted database is usually smaller and often runs faster." Click on the Run button to bring up Compact Database warning screen "Make sure that everyone is off the system START?." Click on the Yes button to begin compacting the database. When compacting process has been completed, the Process Completed screen appears. Click on the OK button from the Process Completed screen to close Compact Database windows.
Running Compact Database from Kform Project Manager:
To run Compact Database from Kform Project Manager, select Compact Database from the Utilities Database Maintenance menu selection. The following message appears on the Compact Database screen: "As the users change data, the database file can become fragmented and use more disk space than is necessary. Run this Compact Database option periodically to compact your database to defragment the database file. The compacted database is usually smaller and often runs faster." Click on the Run button to bring up Compact Database warning screen " Make sure that everyone is off the system START?." Click on the Yes button to begin compacting the database. When compacting process has been completed, the Process Completed screen appears. Click on the OK button from the Process Completed screen to close Compact Database windows and return to the main Kform Project Manager screen.
|