Microsoft KB Archive/236536

= MOD2000: Access Run-Time Cannot Be Installed Without a Database Shortcut =

Article ID: 236536

Article Last Modified on 7/30/2001

-

APPLIES TO


 * Microsoft Office 2000 Developer Edition

-



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
 In Access, create a new database called MyData.mdb that has a startup form named frmTest. In Excel, create a new workbook named MyWorkBook.xls. On the Tools menu, point to Macro, and then click Visual Basic Editor. 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

 In the Package and Deployment Wizard, click Package.</li> Click Next on each page, and accept the defaults until you see the page named Package and Deployment Wizard - Included Files.</li> Click to select the Include Access Runtime check box.</li> 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.</li> Continue clicking Next and accepting the defaults until the package is finished.</li> Run Setup for the package on a computer that does not have Access or the Access Run-Time version installed.</li></ol>

Note that the workbook is installed without starting the Access Run-Time Setup included with the package.

Additional query words: prb

Keywords: kbnofix kbpdwizard kbprb KB236536

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.