Access 97 and Access 2000 on same machine

Installing Access 2000 when Access 97 Is Already Installed

If you already have Access 97 on the computer, and you want to add Access 2000, follow these steps:

close all applications
Install Access 2000 or Office 2000. Run setup.exe rather that using Add/remove software. Be sure to select the Custom installation option.
When prompted, change the installation location for Access 2000 or Office 2000 to a folder other than C:\Program Files\Microsoft Office\ or the folder that you installed Access 97 or Office 97 into. For example, you can install Access 2000 or Office 2000 to a folder named C:\Program Files\Microsoft Office2K\
When prompted, select the option to keep the earlier versions of the Office programs on the computer. This is an all-or-nothing choice; you eith$ keep all earlier versions of the Office programs, or you lose them all.
Complete the rest of the installation and restart.

NOTE:

The Office 97 shortcuts on the Start menu may be overwritten by the Office 2000 shortcuts. If you want Office 97 shortcuts on the Start menu, you must add them manually.
ODBC and Jet Engine settings not updated

Installing Access 97 when Access 2000 Is Already Installed

If you already have Access 2000 on the computer, and you want to add Access 97, there are some additional steps you must follow.

When you try to install Access 97, you have to avoid the "No license..." error message caused by the presence of the Hatten font, which is installed by Access 2000 and Office 2000. Also, if the Access 97 installation finds a newer version of the Msaccess.exe file on the computer, it will not install the 97 version of the Msaccess.exe file.

Click Start, point to Find, and then click "Files or Folders".
Find the Hatten.ttf file, and then rename it to Hatten.sav. You must do this to avoid the "No license..." error message when you start Access 97.
NOTE: You can find the Hatten.ttf file in the Fonts folder under the name, Haettenschweiler.
Find the existing version of the Msaccess.exe file, and then rename it to "Msaccess.2k" (without the quotation marks). Before you rename it, confirm that the version of the Msaccess.exe file is 9.0x by right-clicking the file, and then clicking Properties. Then click the Version tab
Install Access 97 or Office 97.
When prompted, click Change Directory to install Access 97 in a folder other than the folder in which Access 2000 is installed. For example, install the program in a folder named C:\Program Files\Microsoft Office97\.
After the installation is finished, find the Msaccess.2k file and rename it back to Msaccess.exe. Also, find the Hatten.sav file and rename it back to Hatten.ttf.
If you are performing this procedure on Windows 2000, in order to rename the hatten.ttf font you may have to boot the PC with the 4 recovery console disks made when Win 2000 was installed, just so that the file was not in use - every time you try renaming from Windows 2000 proper it said 'access denied file in use'. It is quite laborious using the recovery console it takes 10-15 mins to boot up in the first place, however it then works. Renaming MSAccess.exe for Access 2000 had no troubles.

Problems After Installing Access 97 and Access 2000 on the Same Computer

If the procedures described in this article were not followed when the second version of Access was installed on the computer, you may have problems when you try to start Access. Following are descriptions of the error messages or problems that you may encounter, as well as the resolutions.

Microsoft Access can't start because there is no license for it on this machine.
To resolve this behavior, follow these steps:

Click Start, point to Find, and then click "Files or Folders".
In the Named box, type "Hatten.ttf" (without the quotation marks).
In the Look In box, type "C:\Windows\Fonts " (without the quotation marks) or the path to the Fonts folder on your computer.
Click Find Now to start the search.
Under Name, right-click the Hatten.ttf file, and on the menu that appears, click Rename.
Change the name of the file to Hatten.sav.
NOTE: You can find the Hatten.ttf file in the Fonts folder under the name, Haettenschweiler
Insert your Access 97 or Office 97 CD into the CD-ROM or DVD-ROM drive.
Click Start, and then click Run.
Type the command to run the Microsoft Access Setup program and use the /y switch to reregister Access 97. For example, type: " D:\Setup.exe /y " (without the quotation marks)
In the Installation Maintenance Program dialog box, click Reinstall. The Setup program updates the system registry for Access. When Setup is finished, start Access.

NOTE: Following the steps in this procedure has the side effect of changing all the Start menu shortcuts to point back to the Office 97 programs. If you want to have the shortcuts point to the Office 2000 programs, run Office 2000 Setup in maintenance mode, and then click Repair. You can then select to repair the Start menu shortcuts.

Can't find the database you specified, or you didn't specify a database at all. Specify a valid database in the command line and include a path if necessary. There are two main causes for this error:

- You installed Access 97 on a computer that has the Small Business Customer Manager 2000 installed. For additional information about resolving this problem, view the article in the Microsoft Knowledge Base: Q235279 ACC2000: "Can't Find the Database You Specified" Error When Starting Access 97 on Computer with Office 2000 Small Business Tools
- You installed Access 2000 on a computer that already has both Access 97 (full version) and an Access 97 run-time application installed. For additional information about resolving this problem, view the article in the Microsoft Knowledge Base: Q235280 ACC2000: "Can't Find the Database You Specified" Error When Starting Access 97 After Upgrade to Office 2000

You may also notice that one or both versions of Access are using the wrong workgroup information file. For additional information about resolving this problem, view the article in the Microsoft Knowledge Base: Q241230 ACC2000: Workgroup Information File Is Reset to Default System.mdw After Self-Registration

Registry problem when back installing Access 97 on a PC with Access 2000

The registry gets changed so that all files ending in the various mdb style extensions all get associated with Access 97.
This is a problem for files that are really A2000 files as they are seen as 'un recognised database format'. Going via the standard Tools / Folder Options / File Types box in Windows 2000 does not work as somehow it sees 'Microsoft Access' as the descriptor name for both MS Access 97 and 2000, even when you browse to find the application you really want to use to open the file.
To get round this, edit the registry to hack the CLASS entry for mdb files so that they open with Access.9 not Access.8 (thanks to Tim Finch, FosterFinch Ltd)