How to link tables in JCMS

Linking JCMS interface with JCMS database tables (Office 2003): 

There are two Microsoft Access files that make up the JCMS application. The file JCMS.mdb contains the user interface forms, the queries, and reports. The second, JCMS_db.mdb, contains the data tables. You must link JCMS.mdb to the tables in JCMS_db.mdb.

To fix this problem:

  1. Bring up JCMS
  2. Hit F11
  3. Right click on the ' Tables'  icon in the ' Objects' dialog
  4. Select  ‘Link Tables ..’
  5. Navigate to your JCMS_db.mdb file
  6. Select it: ' Link'
  7. 'Select All'  the tables, ' OK'
  8. Restart JCMS

Linking JCMS interface with JCMS database tables (Office 2007): 

  1. From toolbar, select ‘External Data’ tab.
  2. Select ‘Access’ database.
  3. ‘Browse’ to the JCMS database (jcms_db).  Select ‘Open’.
  4. Select ‘Link to the data source by creating a linked table’ button.
  5. Select ‘OK’
  6. ‘Link Tables’ window opens.
  7. Select ‘Select All’
  8. Select ‘OK’