Known issues - the JCMS MS Access Upgrader

JCMS Community Forum
Have your questions answered by JCMS professionals

The latest release of the JCMS Upgrader for msAccess database is v4.5.0 (released 06/25/2012)

1- Windows Vista and Windows 7:
msWindows security prevents the Upgrader from creating a backup folder.  This causes an 'Access is denied' error message in the Upgrader event log.
     The fix:  right click on the 'The Jackson Laboratory' folder (default location is  C:\Program Files\The Jackson Laboratory).
                    select 'properties'.
                    select 'security' tab.
                      select group 'TrustedInstaller' and change permissions to full control.  Apply/OK.
                      select group 'Administrators' and change permissions to full control.  Apply/OK.
                      select group 'Users' and change permissions to allow 'Modify' or 'Full Control'.  Apply/OK. 
     Upgrader will now work as designed.

2- There is an error oddity that we see from time to time (error message "LinkTable: Dao exception: Object 'Allele' already exists.").  Basically what happens is that the database was upgraded successfully, but the last step to link a few tables from the interface file to the database does not finish.  There are many reasons why this could happen. All you need to do to complete the upgrade, is to do the following:

(MS Access 2007 instructions):
Close the upgrade utility.
Open the interface file \JCMS.mdb.
At the Welcome Screen hit the F11 button.
Find the Tables section in the Access Objects list to the left.
Highlight all the linked tables and delete them.
Click the External Data Tab at the top.
Click Access Icon.
Select Link to data source ....
Set filename \JCMS_db.mdb   Click OK.  Select all tables.  Click OK.
Close JCMS and restart.