Front End Updates

When a new Executive update is released, the Executive.mdb (and/or ExecutiveReports.mdb) file may need to be replaced on each workstation to complete the upgrade. The following instructions outline the steps required to update the front end files. This may also be the case if you have a corrupted front end file, and need to replace it with a clean front end file.

Download Latest Files

Front End files for most of the 07/08 revisions can be found on the Updates page and are available for download. An easier method would be to copy the Executive.mdb file from a working computer, as you would not have to link the paths.

Choose to Save the file to your shared server folder. You may want to create a new folder for the update such as Executive 08-01-29 FE (where 08.01.29 is the version number of the update). Save the file here, and double click it to extract it after installation for .exe files, or unzip it for .zip files.

Updating Workstations

Each workstation will need to be updated with the new front end files. One way to save time is to link the files on the first workstation, then copy those linked files to the remaining workstations (assuming that all workstations use the same mapped drives and linking).

First Workstation

Open Executive, and go to Maintenance-System-Link Data. Write down your linkings for each of the applicable files. Below is an example of common linkings, but it may differ depending on your drive mappings. Also check your version by going to Help-Version, so that you can verify afterwards that the Executive (and/or ExecutiveReports) version has been updated.

Sample Executive.mdb Linking Paths

|| File || Path || | ExecutivePrinterSetup | C:\Executive\ExecutivePrinterSetup.mdb | | ExecutiveReports | C:\Executive\ExecutiveReports.mdb | | ExecutiveData | X:\ExecutiveData.mdb | | ExecutiveSetup | X:\ExecutiveSetup.mdb | | ToLocation1 | X:\ToLocation1.mdb | | ToLocationOther | X:\ToLocationOther.mdb |

There should be 6 lines to link in Executive, if you have more/less please replace the Front end file again as it may be corrupted.

Sample ExecutiveReports.mdb Linking Paths

|| File || Path || | ExecutiveData | X:\ExecutiveData.mdb | | ExecutiveSetup | X:\ExecutiveSetup.mdb |

There should be 2 lines to link in Reports, if you have more/less please replace the Front end file again as it may be corrupted.

Updating Files

1. Open My Computer and navigate to your shared folder, and into the server's 08-01-29 FE folder.
2. Copy the Executive.mdb (and/or ExecutiveReports.mdb) file and paste it into the C:\Executive\ folder (C:\Program Files\Executive for 07 Version).
3. Open Executive, go to Maintenance-System-Link Data and change all the paths to match the ones you copied down earlier.
4. When the paths are correct, hit OK to link the data.
5. If you also need to link Executive Reports, go to reports and link from Maintenance-Link Data.

Once the data is linked on the first workstation, go to this workstation's C:\Executive\ folder. Copy Executive.mdb (and/or ExecutiveReports.mdb) and paste them into your shared 08-01-29 FE folder. These will then be used for updating remaining workstations.

To check that everything is linked properly, go to Sales-Find a Sale and make sure today's sales are showing. You can also go to Help-Version to make sure the Executive Version number has been updated to the latest version.

Remaining Workstations

After the first workstation is completed, you can use the pre-linked files on the remaining workstations and update them individually.

1. Open My Computer and navigate to your shared folder, and into the server's 08-01-29 FE folder.
2. Copy the Executive.mdb (and/or ExecutiveReports.mdb) file and paste it into the C:\Executive\ folder (C:\Program Files\Executive for 07 Version).

To check that everything is linked properly, go to Sales-Find a Sale and make sure today's sales are showing. You can also go to Help-Version to make sure the Executive Version number has been updated to the latest version.