The JCMS Upgraders
JCMS Community Forum
Have your questions answered by JCMS professionals
The JCMS Upgrader for MySQL database upgrades previous versions of a JCMS MySQL database to v4.8.4
Upgrade instructions for MySQL database: (click here)
**Please keep in mind that the MS Access backend WILL NOT be supported past version 4.6.0. To get the latest release of JCMS, convert your database to MySQL by using the JCMS Access to MySQL conversion tool, which can be
downloaded below.
The JCMS Upgrader for MS Access database upgrades previous versions of JCMS to v4.6.0 or v3.4.3
- Download JCMS MS Access Upgrader for v3.4.3 (supported on MS Access 2003)
- Download JCMS MS Access Upgrader for v4.6.0 (supported on MS Access 2007 or 32-bit 2010)
JCMS MS Access Upgrader instructions
The following instructions are for users who have their JCMS interface linked to an MS Access database. If you have taken the steps necessary to migrate to MySQL, utilize the upgrade instructions for MySQL.
If you have earlier versions of JCMS installed, you can upgrade to version 4.6.0 or 3.4.3 by using the upgrade utility. This utility will backup and upgrade your current installation to version 4.6.0 or 3.4.3 with no loss of data.
Close JCMS if open. If you had installed a previous version of the Upgrader, select uninstall/remove from Control Panel.
Download and install the Upgrader by running the Microsoft Installer file (select the Download link above). The upgrade utility will be installed where you choose. You can run the upgrade utility from the desktop or from the folder where you installed it. Your data will be backed up as well as your previous installation of JCMS.
After installing the upgrade utility, the software will be automatically invoked, and you will see the screen:
To upgrade your installation:
1- Set permissions for Users and “TrustedInstaller” to full control. See the FAQ page for details.
2- Use the first Browse button to find your working copy of JCMS.mdb. This file is in the folder C:\Program Files\The Jackson Laboratory\JAX-CMS\interface, by default.
3- If the upgrader cannot find the JCMS_db.mdb file, you will need to select the folder where it resides by clicking the second Browse button, and navigating to its folder. This file is in the folder C:\Program Files\The Jackson Laboratory\JAX-CMS\database, by default.
4- Finally, click Upgrade. All your files will be backed up. Your new installation will have all your data intact.
5- If you have multiple users, go to ‘Help with multi-user upgrades’ on the Upgrader FAQ page.