Upgrading Microsoft Access database schemas for customized Datacap applications

Upgrade Microsoft Access databases that support customized Datacap applications.

About this task

From V9.0 onward, Datacap provides Microsoft Access databases that contain appropriate schemas for each Datacap version. The Access databases support the Datacap standard, non-customized applications. For standard applications, no database upgrade is required.

For customized applications, you must add your database customizations to a database that is compatible with the newDatacap version. Complete the following steps:

  1. In your Datacap application's folder, replace the old database files with unmodified database files from the \Datacap\Templates\FormTemplates\ folder of the Datacap target version. The following example assumes that you have an existing "MyApp" application in C:\Datacap\MyApp\.
    Tip: Save a copy of your old database files before you create and customize the new databases. Just in case.
    • Customize the Administration database:
      1. Copy the new database file C:\Datacap\Templates\FormTemplates\FormTemplatesAdm.mdb to the application's folder C:\Datacap\MyApp\.
      2. Delete the old database file C:\Datacap\MyApp\MyAppAdm.mdb, rename the new database file from C:\Datacap\MyApp\FormTemplatesAdm.mdb to C:\Datacap\MyApp\MyAppAdm.mdb.
      3. Use Microsoft Access to add your customizations to the new database C:\Datacap\MyApp\MyAppAdm.mdb.
    • Customize the Engine database:
      1. Copy the new database file C:\Datacap\Templates\FormTemplates\FormTemplatesEng.mdb to the application's folder C:\Datacap\MyApp\.
      2. Delete the old database file C:\Datacap\MyApp\MyAppEng.mdb, rename the new database file from C:\Datacap\MyApp\FormTemplatesEng.mdb to C:\Datacap\MyApp\MyAppEng.mdb.
      3. Use Microsoft Access to add your customizations to the new database C:\Datacap\MyApp\MyAppEng.mdb.
    • Customize the Fingerprint database:
      1. Copy the new database file C:\Datacap\Templates\FormTemplates\FormTemplatesFingerprint.mdb to the application's folder C:\Datacap\MyApp\.
      2. Delete the old database file C:\Datacap\MyApp\MyAppFingerprint.mdb, rename the new database file from C:\Datacap\MyApp\FormTemplatesFingerprint.mdb to C:\Datacap\MyApp\MyAppFingerprint.mdb.
      3. Use Microsoft Access to add your customizations to the new database C:\Datacap\MyApp\MyAppFingerprint.mdb.