Microsoft Access 2000 and Express Software Manager
Technical Note 1414
Last Reviewed 13-Feb-2002
Applies To
Express Software Manager version 4.5 through 5.x
Summary
Express Software Manager versions through 5.x require Microsoft Access 97 (full or runtime version) on the workstation where Express Console, Express Reports, or the Library Manager service are to be run. If you must install Express on a machine where Access 2000 is or will be installed, some steps may be necessary to get Access 97 and Access 2000 to work properly on the same machine.
Express Requires Microsoft Access 97
Express Software Manager requires Microsoft Access 97 (full or runtime version) to consolidate data for reports. You can install the runtime version of Access 97 when you install Express Software Manager. If you have installed or are preparing to install Access 2000, the installation path must be different than the location where you installed Access 97 on any machine where Express Console, Reports, or the Library Manager service will be run.
Note: The Library Manager service machine is affected by installations of Access 2000 only if the Library Manager service is used to perform post consolidations. (Post consolidation is enabled in Express Console under Library Properties. On the Consolidate tab, there is a check box to Enable Post Consolidate Work.)
Running Express on a Workstation with Access 2000
If Microsoft Access 2000 must be installed on a workstation that is already running Express Console, Express Reports, or the Library Manager service, Access 2000 must be installed into a folder other than the one where you installed Access 97. By default, Access 97 (full or runtime version) is installed to Program Files\Microsoft Office\Office. Note: When installing Access 97 you cannot change the installation location for the runtime version, but you can specify the installation path for the full version.
If you want to install and use more than one version of Access on the same computer, Microsoft recommends that you install the earliest version first. For more information, about this see Microsoft Knowledge Base articles Q159333 and Q218861:
The articles indicate that installing the earliest version first is necessary "...because of the way registry keys, shared programs, file extensions, and other settings are managed for each version of Office, and for the programs that are included with each version of Office."
The following sections describe the most common scenarios encountered when configuring Express Software Manager, Microsoft Access 97, and Access 2000 onto the same workstation.
- Installing Access 2000 After Access 97 was Installed
- If Access 97 (full version) was Already Upgraded to Access 2000
- Installing Access 97 After Access 2000 was Installed
Follow the appropriate steps for your environment.
Installing Access 2000 After Access 97 was Installed
When installing Access 2000 onto a workstation where Access 97 is already installed, the setup will prompt you to Upgrade Now or Customize. You must choose Customize, and then choose an installation location other than the one where you installed Access 97. Note: Do not overwrite Access 97 (full version) with Access 2000.
If Access 97 (full version) was Upgraded to Access 2000
If you have already upgraded the full version of Access 97 to Access 2000 on the Express Console machine, running reports from Express Console will launch Access 2000 and prompt you to upgrade the Express.mdb file. The upgrade will fail (with a Visual Basic conversion error). If you have already upgraded to Access 2000, Express Metrix technical support recommends that you follow these steps:
- Uninstall Access 2000.
- Uninstall Access 97.
- Re-install Access 97. Note: After installing Access 97, you should update the Microsoft Jet Database Engine. For more information, see Technical Note 1284.
- Re-install Access 2000 into a folder other than the one where you installed Access 97. Note: During the Access 2000 setup, you will be prompted to Upgrade Now or Customize. Choose Customize, and then choose the installation location.
- Download and run the Microsoft tool, AcLicn97.exe, from Microsoft's web site in order to update the registry entry for Access 97:
Installing Access 97 After Access 2000 was Installed
If you are preparing to install Express Software Manager version 4.5 or higher onto a machine that already has Access 2000 installed, you must also install Access 97 (full or runtime version).
Access 97 (runtime): During the installation of Express Console, you are prompted to select the components you want to install. Select the Microsoft Access Runtime check box if you do not already have Microsoft Access 97 installed. Note: The runtime version of Access 97 installs into the folder Program Files\Microsoft Office\Office. If Access 2000 is already installed in that location, then the Access 97 runtime will not install over it. You must uninstall Access 2000, and re-install it into a folder other than Program Files\Microsoft Office\Office. You can then install the runtime version of Access 97.
Access 97 (full version): You must install a full version of Access 97 into a folder other than the one where you installed Access 2000. You also will need to run the Microsoft tool, AcLicn97.exe, in order to successfully run Access 97 on a machine where Access 2000 was previously installed (see section below).
Using AcLicn97.exe to Resolve Access Startup Error
If you installed Access 97 after installing Access 2000, you may receive the error "Microsoft Access can't start because there is no license for it on this machine" when you launch Access 97. Microsoft created a tool, AcLicn97.exe, to correct this problem. This tool is available on the Microsoft web site:
Follow the installation instructions in the associated Readme.txt file.
Additional Resources
The following Microsoft Knowledge Base articles offer additional information about running multiple copies of Microsoft Access:
Related Technical Notes
Related Technical Notes
| 1284 |
Express Software Manager and the Microsoft Jet Database Engine |
| 9989 |
Express Software Manager 6.0 Technical Notes |
| 
