INSTALLATION

You are about to perform an update of an existing data management system. While there are a number of steps involved, your careful attention to each will ensure that the process is trouble-free. Please recognise that this is one of your core business management systems and that it is worthwhile spending some time to get it right.

Firstly, it is recommended that you read through everything here once before starting the process so that you have an overall appreciation for what is required. Then just take each section step by step to ensure a successful installation.

Consider this IMPORTANT information about MS Access bugs and Service Packs

Some versions of Microsoft Access have bugs. Microsoft issues Service Packs to fix these.

For some versions of Microsoft Access it is important that particular Service Packs are applied before installing and using Training Provider.

Before proceeding with installation of Training Provider please determine which version of Microsoft Access you are using and, if you are using MS Access 2000 or 2007, also determine which Service Pack has been applied. Click here if you need advice on how to do this.

If you are running MS Access 97, 2002/XP or 2003 there are no specific Service Pack requirements in relation to installing or running Training Provider but it is generally advisable to install any that have been released.

If you are running MS Access 2000 please ENSURE that Service Pack 3 has been applied (and note that it is necessary to apply Service Pack 1a before applying Service Pack 3).

If you are running MS Access 2007 please ENSURE that Service Pack 1 has been applied.

To obtain Service Packs please visit www.microsoft.com and use the search facility on that website to find the Service Pack(s) applicable to your version of Microsoft Office. eg For Access 2007 search for "Office 2007 Service Pack". Please follow the Service Pack installation instructions on the Microsoft website - and consult Microsoft if you need assistance with this because it is a system maintenance issue not an Training Provider issue.

Consider this IMPORTANT information about MS Access security settings

If you are running a version of MS Access other than 2003 or 2007 you can skip this section.

MS Access 2003 and 2007 have a security feature which affects Training Provider during startup (for normal use) - and also during installation.

By default MS Access 2003 and 2007 interrupt startup to display one or more warning messages when the application being opened is not digitally signed (and Training Provider is not). Since Training Provider is opened during installation this also interrupts installation. When the appropriate button on a warning dialog is clicked the startup (and installation when startup is for the purpose of installation) resumes.

For MS Access 2003 you can change some settings, BEFORE installing Training Provider, so that these warning messages do not appear. Click here to find out how to do this.

For MS Access 2007 you cannot avoid the warning message during installation of Training Provider but you can add a setting AFTER installation has been completed so that the warning message does not appear every time you start Training Provider. This is referred to below after the Perform The Update section.

Make Backups

Before performing the update, please make sure that you have a backup copy of the following files:

• Data File - which holds your data;
• Workgroup Security File - which holds usernames for your staff; and
• Custom Interface File (if you have been using it) - which holds custom queries and reports that you have built yourself using Microsoft Access.

The following notes are provided to help you find these files in case you don't know where they are. If you know which files they are, and you've already made backups, you can skip to the next section (Get the Update Installer).

Data File

The usual name for the Data File is TrgPr_DB.mdb.

For a Single-User setup it is usually located in C:\Program Files\TrgPr.

To check the name and location of your Data File:

1. Open the Training Provider Application Interface.
2. Click File on the menubar and then See Data File Location.

Training Provider (both the Application Interface and the Custom Interface) must be closed on all user's computers before making a backup copy of the Data File.

You can verify that Training Provider is closed on all user's computers by checking that a file named TrgPr_DB.ldb does not exist in the same folder as the Data File. (This assumes that the Data File has it's standard name; ie TrgPr_DB.mdb).

Workgroup Security File

The usual name for the Workgroup Security File is TrgPrUsr.mdw. To find the location of your Workgroup Security File:

1. Right click on the Start menu and click Open.
2. Open the Programs folder, followed by the Training Provider folder.
3. Right click on Application Interface and click Properties.
4. Open the Shortcut tab.
5. Examine the Target property. This property will be similar to the following, and the location and name of the Workgroup Security File will be specified in the middle section of the property:
   "C:\Program Files\Microsoft Office\Office\MSAccess.exe" /wrkgrp "C:\Program Files\TrgPr\TrgPrUsr.mdw" "C:\Program Files\TrgPr\TrgPr_IF.mde"

Custom Interface file

In the MS-Access 2000/2002/XP/2003/2007 version of Training Provider the Custom Interface File is named TrgPr_IFCustomX2.mdb.

In the MS-Access 97 version of Training Provider the Custom Interface File is named TrgPr_IFCustom.mdb.

To see if you have a Custom Interface on your computer, first check in the Windows Start Menu under Programs -> Training Provider. If there is an entry there for Custom Interface, follow these steps to determine the location and name of the Custom Interface File:

1. Right click on the Start menu and click Open.
   Open the Programs folder, followed by the Training Provider folder.
2. Right click on Custom Interface and click Properties.
3. Open the Shortcut tab.
4. Examine the Target property. This property will be similar to the following, and the location and name of the Custom Interface File will be specified in the last section of the property:
   "C:\Program Files\Microsoft Office\Office\MSAccess.exe" /wrkgrp "C:\Program Files\TrgPr\TrgPrUsr.mdw" "C:\Program Files\TrgPr\TrgPr_IFCustomX2.mdb".

If an entry did not exist in the Windows Start Menu for the Custom Interface, please check for a shortcut named Custom Interface on the Desktop. If you find one:

1. Right click on the Custom Interface shortcut and click Properties.
2. Open the Shortcut tab.
3. Examine the Target property. This property will be similar to the following, and the location and name of the Custom Interface File will be specified in the last section of the property:
   "C:\Program Files\Microsoft Office\Office\MSAccess.exe" /wrkgrp "C:\Program Files\TrgPr\TrgPrUsr.mdw" "C:\Program Files\TrgPr\TrgPr_IFCustomX2.mdb".
4. Delete the shortcut from your Desktop. (The installer will create a new one in the Start Menu if necessary).

Data File Conversion

Sometimes a new version of Training Provider will require you to perform a Data File Conversion before you install the update, so please follow these steps:

1. Open Training Provider.
2. See which version you are currently using by clicking on Help (on the menubar) and then About Training Provider.
3. If you are:
• using any version prior to 4.000, then you need to perform a Data File Conversion BEFORE you install the latest update, so please go to the Data Conversion Utility page.
• using version 4.000 or later, skip to the Get the Update Installer section.

Get the Update Installer

Click on the following link and, when prompted, choose Save (not Open). Then, in the Save As dialog, select the folder to which you'd like to save the installer on your computer (make a note of it because you'll need to go to it in a moment) and click Save.

Download the installer

Perform the Update

To install the update:

1. If any part of Training Provider (Application Interface, Custom Interface or the old Professional Tools Interface) is currently in use, close it.
2. If your Workgroup Security File is not in the same folder as your Data File, move it to this folder.
3. If you located a Custom Interface File and it has not been used (ie you have not created any custom queries or reports etc), delete it.
4. If you located a Custom Interface File, and it has been used, and it is named TrgPr_IFCustom.mdb (ie a MS-Access 97 file), rename it to TrgPr_IFCustomX2.mdb. (The next time it is used MS-Access will prompt you to convert it. You will need to save it with a new name to permit the conversion and must then rename it back to TrgPr_IFCustomX2.mdb).
5. If you located a Custom Interface File and it has been used, and you are using the Update installer to move Training Provider to a different computer, manually create the Application Folder (usually C:\Program Files\TrgPr) and copy the Custom Interface File into it.
6. Open Windows Explorer.
7. Go to the folder to which you saved the installer.
8. Double-click on the file UpdateTrgPrX2.exe.
9. If the installer cannot identify the Application Folder where Training Provider was, or is to be, installed (usually C:\Program Files\TrgPr), or the Data Folder which holds the Data File and the Workgroup Security File, it will prompt you for these locations. It will then proceed to update your system.

Make the Application Folder a Trusted Location

If you are using a version of MS Access PRIOR to MS Access 2007 skip this section.

If you are using MS Access 2007 it is recommended that the workstation folder holding Training Provider be set as a Trusted Location - as described here.

Tidy Up

It is often discovered that users have multiple Data Files on their computers. There should be only one Data File. Backups should be moved to external media. Retaining old copies of the Data File on your computer can lead to major problems - such as entering data into the wrong file or deleting the real file!

eg If your Data File is on a server you may have additional copies (not being used) on your workstation (such as in C:\Program Files\TrgPr).

So it is recommended that you check around and then (after making a copy on other media just to be safe) delete old copies of the Data File.