MOD2000: Access Run-Time Cannot Be Installed Without a Database Shortcut (236536)


The information in this article applies to:

  • Microsoft Office 2000 Developer
This article was previously published under Q236536
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

When you install a package on a computer, the Microsoft Access Run-Time version is not installed, even though you included the Access Run-Time files in the package, and there was no previous copy of Access on the target computer.

CAUSE

It is not enough to click to select the Include Access Runtime check box. You must also provide a shortcut in the Package and Deployment Wizard that points to an Access database.

RESOLUTION

In the Package and Deployment Wizard, make sure that you include an Access database, and that you have a shortcut on the Start Menu Items page that points to that database. For example, if you include a file that is named MyData.mdb, and you want it to be placed in the default application folder, the shortcut for it would have the following properties:

Name: MyData
Target: $(AppPath)\MyData.mdb
Start in: $(AppPath)

If this shortcut, for one of the reasons described in the "More Information" section, does not exist, you must add it at the Start Menu Items page of the Package and Deployment Wizard.

MORE INFORMATION

The wizard always creates a shortcut for the database that is open while you run the wizard. You can usually see this behavior by running the Package and Deployment Wizard in an application other than Access. For example, if you run the wizard from Microsoft Excel, and you have a Microsoft Excel spreadsheet called Payroll.xls open, the wizard automatically adds Payroll.xls to the package and creates a shortcut for it. However, in that case, if you click to select the Include Access Runtime check box, and even if on the Add Files page you include an Access database, a shortcut for it is not automatically created. In this case, you must still create a shortcut manually on the Start Menu Items page. If you do not create any shortcuts to any included Access databases, the package does not install the Access Run-Time version on the target computer.

When you run the wizard from Microsoft Access, a shortcut for the database that you have open is automatically created. All that is required in this case is that you click to select the Include Access Runtime check box. However, if you then delete that shortcut at the Start Menu Items page, the Access Run-Time version is not installed on the target computer.

Steps to Reproduce Behavior

  1. In Access, create a new database called MyData.mdb that has a startup form named frmTest.
  2. In Excel, create a new workbook named MyWorkBook.xls.
  3. On the Tools menu, point to Macro, and then click Visual Basic Editor.
  4. On the Add-ins menu, click Package and Deployment Wizard. For additional information about starting the Package and Deployment Wizard, click the article number below to view the article in the Microsoft Knowledge Base:

    236143 MOD2000: How to Start the Package and Deployment Wizard

  5. In the Package and Deployment Wizard, click Package.
  6. Click Next on each page, and accept the defaults until you see the page named Package and Deployment Wizard - Included Files.
  7. Click to select the Include Access Runtime check box.
  8. Browse to the ODETools\v9\AccessRT\Data1.msi file on the Office Developer 2000 CD, click Open, click Add, and then click OK to add MyData.mdb to the package.
  9. Continue clicking Next and accepting the defaults until the package is finished.
  10. Run Setup for the package on a computer that does not have Access or the Access Run-Time version installed.
Note that the workbook is installed without starting the Access Run-Time Setup included with the package.
Modification Type:MajorLast Reviewed:7/30/2001
Keywords:kbPDWizard kbprb KB236536
©2002 Microsoft Corporation. All rights reserved.