Re-linking or Networking the Data Files
FARM consists of three files
1.FARM_fe.accdr : Front-end Graphical User Interface (GUI)
2.FRAM_be.accdb : Back-end User Data Containing Files
3.Dictionary.accdb : User dictionary
C:\Program Files (x86)\On Safe Lines QHSE Software\First Aid Risk Assessment Management.
XP Users please note: Our software will also work in Windows XP however, the user will need to perform some one time initial set-up routines which are managed automatically in later operating systems, this routine requires the user to locate files 2 & 3 (see above) using the built-in semi-automated re-linking routine.
Changing the location of your data containing files.
It is not unreasonable for users to wish to network WRAM so the multiple users can access the data contained within the back-end file. Other uses may wish to move or install WRAM to a different location other than the default directory. (for example, if their PC has no C:\ drive)
WRAM has several built-in re-linking routines which will help to semi-automatically detect the data files have been moved from where they are expected to be found.
TIP: Use can see the current location of you data containing files in the list box labelled 'Current User Table Locations'
The tables held within each of files 2 & 3 are shown in the list box labelled 'Current Table and File Locations'
Option 1. Relink Data Tables Options.
There are two options here User Driven and Automated.
User Driven : This option brings up the file dialog box and asks the user to point to the location of files 2 & 3 (see above)
Relink Quick : This option checks one table in each of file 2 & 3 and if found returns no error, if not found it brings up the file dialog box and asks the user to point to the location of files.
Relink Full : This option checks all tables in each of file 2 & 3 and if found returns no error, if not found it brings up the file dialog box and asks the user to point to the location of files.
Option 2. Reset Default Table Links
Windows Vista, Win 7 & 8: If files 2 & 3 exist in the installation default directory the procedure will attempt to re-link to theses files. C:\Program Files (x86)\On Safe Lines QHSE Software\First Aid Risk Assessment Management.
Windows XP: If files 2 & 3 exist in the installation default directory for XP the procedure will attempt to re-link to theses files. C:\Program Files\On Safe Lines QHSE Software\First Aid Risk Assessment Management.
Option 3. Access Linked Table Manager
This options brings up the link table manager. To use the linked table manager;
1.Select the Always prompt for new location check box.
2.Select the check box for the tables whose links you want to change, and then click OK.
3.In the Select New Location of either table in file 2 or 3 from the dialog box (you can only do one table at a time), specify the new location, click Open, and then click OK.
The Linked Table Manager doesn't move database or table files. For information about moving database or table files to a new location, search Microsoft Windows Help. Once you have moved a database or table, you can use the Linked Table Manager to refresh links.
Option 4. Attempt Manual Path Reset
This option allows the user to simply type the location of files 2 & 3 in the text box. If the files 2 & 3 are where the user specified the program will attempt to relink the data tables. The 'Current User Table Locations' list box will update to show the current location of files 2 & 3.
This option is use for switching between local and network copies of files 2 & 3, or between live and test data. For example you may wish to leave the default installation directory of files 2 & 3 as your live (current) work, you could the copy this file to another directory, lets say C:\FARM_Testing and then switch back and forth between the two sets of files.
FARM's Linked Table Structure > click here
See sample network diagram
IMPORTANT: The re-linking routine is designed to manage the moving of FARM's data files 2 & 3. Users should not move the GUI file manually as this will cause window registry entry errors and cause the program to un-register itself.
When the programme detects the data files have moved or are not where they were expected to be found, it loads the re-linking routine procedure. The re-linking form shows the location where files 2 and 3 were last located and indicates YES or NO as to whether-or-not they have been found.
Where the form indicates that the file or files have not been located, users can highlight one and one only file from the two offered. Once an entry is highlighted, users can select the locate button, this then opens a standard windows file locating form for users to navigate to the new file location. Once the new file is found, clicking on the file will cause the programme to attempt to re-link to the data file. If the re-linking is successful the form will indicate that the file was found. Users can then re-link the second file if necessary.
Network Usage: FARM has been designed and developed to be multi-user and network efficient. A typical example would be when FARM's data file FARM_be is moved onto a network drive to allow the front end to be placed on numerous user's terminals. FARM always performs best when working on your local computer. However, it is recognised that many users will wish to network FARM. Users may notice a slower than expected performance when connected over a network depending upon various factors such as the design, configuration, speed, traffic, etc. of your company network.
Caution: If you are in a corporate network environment, you should check with your information technology department to determine whether your company has established guidelines concerning enabling content on Access databases.
On Safe Lines QHSE Software Help file v3.3.03 Copyright © 2003-2016 On Safe Lines
On Safe Lines QHSE Software Titles - click on an individual image to learn more.