Article ID: 241738 - View products that this article applies to.
This article was previously published under Q241738
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
When you try to run Access 97 after you install an Access 2000 run-time application that was created by using the Package and Deployment Wizard, you may receive the following error message:
Can't find the database you specified, or you didn't specify a database at all.
Specify a valid database name in the command line, and include a path if necessary.
You have installed the Access 2000 run-time component, and the two following conditions are true:
C:\Program Files\Microsoft Office\OfficeInstalling the Access 2000 run-time component to this path overwrites the existing default installation of Office 97 or Access 97, which are installed in the same path.
To resolve this problem, obtain the Microsoft Office 2000 Developer Service Release 1 (SR-1) FulFillment CD.
NOTE: You cannot correct this problem by downloading and installing the Microsoft Office 2000 Developer SR-1 Update because it does not include Access Runtime SR-1.
To obtain the MOD SR-1 Fulfillment CD, click the article number below to view the article in the Microsoft Knowledge Base:
253566To temporarily work around this problem, do the following.
(http://support.microsoft.com/kb/253566/EN-US/ )MOD2000: How to Obtain and Install Microsoft Office 2000 Developer Service Release 1 (SR-1)
To repair the installation of Access 97, refer to the following article in the Microsoft Knowledge Base:
235280To avoid this behavior on the target computer:
(http://support.microsoft.com/kb/235280/EN-US/ )ACC2000: "Can't Find the Database You Specified" Error When Starting Access 97 After Upgrade to Office
When the user selects the Customize option to install an Access 2000 run-time application, the user must change the path listed in the Install Microsoft Access 2000 Runtime at text box to something other than the default location. For example, a user could specify:
C:\Program Files\Microsoft Office\ARTWhen you distribute Access 2000 run-time applications to users who may have Access 97 installed on their computers, be sure to include instructions that state that they must either manually change the installation path when they use the Customize option, or they should avoid the Customize option and use the Install Now option instead. Although this is an extra step for your users, it ensures that existing installations of Access 97 are not affected.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 Developer SR-1.
When you install an Access 2000 run-time application, you have two installation options: Install Now and Customize. If you select Install Now, the Access 2000 run-time components are installed to the following folder:
C:\Program Files\Microsoft Office\ARTIf you use this folder, any existing installations of earlier versions of Access are protected. If you use the Customize option, the run-time components are installed to a location that the user defines, but uses a default location of
C:\Program Files\Microsoft Office\Officeas defined in the Install Microsoft Access 2000 Runtime at text box. If you continue the installation without changing this path, the run-time components will overwrite any earlier versions of Access in this location. Access 97 uses this path as a default installation location.
IMPORTANT: After you select the Customize option, the installation path will be incorrectly set to C:\Program Files\Microsoft Office\Office, even if you click Back and then click Install Now. The Install Now option will only install to the correct default folder if you have not already clicked Customize.
Steps to Reproduce the BehaviorCAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.
For additional information about installing run-time applications, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/240964/EN-US/ )MOD2000: Installing an Access Run-Time Application May Require Restarting the Computer Several Times