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.

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 OSHAtWork_DB.mdb.

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

To check the name and location of your Data File:

1. Open the OSH At Work Application Interface.
2. Click File on the menubar and then See Data File Location.

OSH At Work (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 OSH At Work is closed on all user's computers by checking that a file named OSHAtWork_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 OSHAtWork_DB.mdb).

Workgroup Security File

The usual name for the Workgroup Security File is osh_usr.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 OSH At Work 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\OSHAtWork\osh_usr.mdw" "C:\Program Files\OSHAtWork\OSHAtWork_IF.mde"

Custom Interface file

In the MS-Access 97 version of OSH At Work the Custom Interface File is named OSHAtWork_IFCustom.mdb.

To see if you have a Custom Interface on your computer, first check in the Windows Start Menu under Programs -> OSH At Work. 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 OSH At Work 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\OSHAtWork\osh_usr.mdw" "C:\Program Files\OSHAtWork\OSHAtWork_IFCustom.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\OSHAtWork\osh_usr.mdw" "C:\Program Files\OSHAtWork\OSHAtWork_IFCustom.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 OSH At Work will require you to perform a Data File Conversion before you install the update, so please follow these steps:

1. Open OSH At Work.
2. See which version you are currently using by clicking on Help (on the menubar) and then About OSH At Work.
3. If you are:
• using any version prior to 1.756, 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 1.756 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 OSH At Work (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 you are using the Update installer to move OSH At Work to a different computer, manually create the Application Folder (usually C:\Program Files\OSHAtWork) and copy the Custom Interface File into it.
5. Open Windows Explorer.
6. Go to the folder to which you saved the installer.
7. Double-click on the file UpdateOSHAtWork97.exe.
8. If the installer cannot identify the Application Folder where OSH At Work was, or is to be, installed (usually C:\Program Files\OSHAtWork), 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.

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\OSHAtWork).

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.