Updating Microsoft Access database schemas from Datacap V9.0 to V9.0.1

This procedure requires Microsoft Access 2013 or later version.

To update the Microsoft Access database schema:

1. Replace the V9.0 Engine database file with an empty V9.0.1 Engine database:
   Important: This step does not preserve existing batches.
   1. Back up the Datacap V9.0 Engine database file in your application folder by renaming it or copying it to a backup location.
   2. Copy the Engine database file from the Datacap V9.0.1 Form Template application (such as \Datacap\Templates\FormTemplate) and paste it into your application folder.
   3. Rename the Datacap V9.0.1 Engine database file that you copied to match the original file name. (The original file name is the name before any renaming done in step 1a.)
   4. Delete existing batch folders from the application.
2. If your application contains custom columns, use Microsoft Access to add your custom columns to the tmbatch table in the new Engine database.
3. Update the Fingerprint database schema to support the ClassifyLayout actions:
   1. Start Microsoft Access and open the following file: \Datacap\Templates\FormTemplate\FormTemplateFingerprint.db (Datacap V9.0.1 schema).
   2. Start another copy of Microsoft Access and open the application's existing Datacap V9.0 Fingerprint database file.
   3. Copy the Class, Feature, and Knowledge tables from the Datacap V9.0.1 schema and paste them into the existing Fingerprint database.
4. Update the Administrative database schema with tables and fields reserved for future use:
   1. Start Microsoft Access and open the following file: \Datacap\Templates\FormTemplate\FormTemplateAdm.mdb (Datacap V9.0.1 schema).
   2. Start another copy of Microsoft Access and open the application's existing Datacap V9.0 Administrative database file.
   3. Copy the views table from the Datacap V9.0.1 schema and paste it into the existing Administrative database.
   4. Close the Datacap V9.0.1 FormTemplateAdm database.
   5. Open the existing adminfo table in design view and add a Number type field that is named db_keymode. Set the Field Size to Long Integer.
   6. Open the existing tmgroup table in design view and add the long integer field gr_key.