Navigation:  5    S:  Latitude Install, Upgrade and Troubleshooting >

5.8 Upgrading from 9000 to the 9200 series

Previous pageReturn to chapter overviewNext page

5.8.1 Overview

 

In this upgrade you will be migrating from the Latitude 9000 series compatible with Microsoft Access versions 2000 and above to the Latitude 9200 series compatible with Microsoft Access versions 2007 SP2 and 2010.

 

This will involve replacing the Latitude program files on all workstations and, if necessary, installing a free Microsoft Access 2007 SP2 or 2010 runtime on workstations that don't have a licensed copy of Microsoft Access installed. If you have trial versions of Access 2007 or 2010 and do not wish to pay to make them licensed, uninstall them and allow the Latitude installer to install a free Access 2007 SP2 or 2010 runtime.

 

The Latitude application consists of two main parts:

The Latitude client program, "Latitude.accde" in the 9200 series or "Latitude.mde" in the 9000 series, installed on every workstation running Latitude. It is replaced every time you update Latitude to a new version. It contains all the Latitude screens, reports and programs and attaches (links to) your data file. In this upgrade from 9000 series to 9200 series you will stop using Latitude.mde and start using a Latitude.accde file

 

A database file "Latidata.mdb", held in a central location on a mapped drive (your Latitude data folder), containing your data that is shared by all your workstations. You should back it up regularly (daily) as nobody can reconstruct it for you if you lose or corrupt it. In this upgrade, you will not be replacing your data file, but only be changing its internal structure

 

You will run the installer in two ways. Firstly on the server to modify your data file and later on all workstations to setup the new Latitude.accde client program

 

Before you start, make yourself aware of the location of your Latitude data folder, Download folder and Backup folder. These folders are usually on a server, but on small peer to peer networks will be on a workstation that is acting as a server. In either case they will usually be named as follows (although the drive letter is often something else):

 

L:\Latitude\

This is the main Latitude folder on a server. It contains your Latitude data file and the following subfolders. It also holds the master copy of the Latitude program file used by the Automatic Deployment Feature (ADF)

 

L:\Latitude\Downloads\

This is the folder the Installer stores all files it downloads for use during the installation. It is also a handy location for you to store any Latitude related downloads and documentation

 

L:\Latitude\Backup\

This is a handy location to store zipped copies of your data file before you upgrade, repair or compact your 'production' data file

 

If you do not have Backup and Downloads folders as above, create them

 

5.8.2 The current version of Latitude only runs on the common 32-bit versions of Microsoft Access 2007 & 2010. Note, 32-bit Access runs fine on 64-bit Windows 7 and Vista. If you are one of the very few people who have 64-bit Microsoft Access 2010 on their workstation, the installer will automatically install the Microsoft Access 2007 runtime to allow Latitude to run

 

5.8.3 If using a Microsoft Access unlicensed or trial version that has expired, use the following steps to remove it

Go to Start Menu

Click Control Panel

Click Programs

Click Program and Features

Select program to Uninstall

 

Microsoft Office (any edition) 2007 or 2010

 

On the top section Click Change

Wait while office setup is initializing

Select Add or Remove Features

Click Continue

Click the Dropdown arrow in Microsoft Access <= uninstall Access only, not all of Office

Click Not Available

Click Continue

Wait for the office setup to finish

Click Close

 

5.8.4 Server Installation

 

Log in to your main workstation as a User with administrator rights

You need full rights to install new software and to create new folders

 

Delete all copies of the old Latitude program file "Latitude.mde"

This is to prevent users from mistakenly running the old 9000 series program after you have upgraded to the new 9200 series

 

Place the Installer zip file, normally LatitudeACxx.xxxx.xx.zip you downloaded from the Latitude website in the Downloads folder

Normally "L:\Latitude\Downloads\"

 

Extract and Run the Installer

Extract the LatitudeACxx.xxxx.xx.exe from LatitudeACxx.xxxx.xx.zip

Double click the installer LatitudeACxx.xxxx.xx.exe to run it

 

5.8.5 Confirm Microsoft Access Runtime version to install (optional)

1732_thumb

click here to zoom

 

If you do not have Microsoft Access installed, confirm the version you want. We suggest Access 2010.

 

Click the "Install Access 2007 Runtime" hyperlink to toggle between Access 2010 and Access 2007

 

5.8.6 Locate your Latidata file e.g. "L:\Latitude\Latidata.mdb"

 

5.8.7 Select the Latitude Install Folder

usually "C:\Lati99\" on a workstation

Click the "Next" button and wait

Click the "I accept the terms of this agreement" tickbox

Click the "Continue" button and wait

Click the "Close" button when Access 2010 runtime installation is finished

 

5.8.8 Locate your Downloads subfolder

1755_thumb

click here to zoom

Normally "L:\Latitude\Downloads\"

Accept the default or use the Browse button to select the correct folder

Click the "Next" button and wait

 

5.8.9 The Installer launches Latitude and displays the "Attach Upgrade" screen

Confirm it shows the correct location of your data file eg. "L:\Latitude\Latidata.mdb"

Click the "AttachUpgrade" button

 

1756_thumb

click here to zoom

 

5.8.11 When asked "You are about to perform a Latitude Upgrade", click "Yes" and wait until the upgrade finishes

1735_thumb

click here to zoom

 

 

5.8.13 Enter your Authorization code and click "OK"

1736_thumb

click here to zoom

 

5.8.14 Click the "Finish" button to close the Installer

 

5.8.15 Workstation Installation

 

Workstation Security Setting

If you are not running Windows XP, you must disable User Account Control (UAC) before installing Latitude. NOTE: After successfully upgrading Latitude you should turn the UAC back on to maintain your security level.

 

Log in to Windows as a User with Administrator Rights

You need full rights to install new software and to create new folders

 

Delete all copies of the old Latitude program file "Latitude.mde"

This is to prevent users from mistakenly running the old 9000 series program after you have upgraded to the new 9200 series

 

Run the Installer

Run Windows Explorer and go to the Latitude Downloads folder eg. "L:\Latitude\Downloads\"

Double click the Installer LatitudeACxx.xxxx.xx.exe to run it again

 

5.8.16 Confirm Microsoft Access Runtime version to install (optional)

If you do not have Microsoft Access installed, confirm the version you want. We suggest Access 2010

Click the "Install Access 2007 Runtime" hyperlink to toggle between Access 2010 and Access 2007

 

Locate your Latidata file

eg. "L:\Latitude\Latidata.mdb"

 

Select the Latitude Install Folder

usually "C:\Lati99\" on a workstation

Click the "Next" button and wait

Click the "I accept the terms of this agreement" tickbox

Click the "Continue" button and wait

Click the "Close" button when Access 2010 runtime installation is finished

 

5.8.17 Confirm the location of your Download subfolder

eg. "L:\Latitude\Downloads\"

Click the "Next" button and wait

 

5.8.18 Installer Finish Screen

Click the "Finish" button to close the Installer

Repeat this Workstation Installation on all your Latitude workstations