MOD2000: Access Run-Time Can't Be Installed Without a Database Shortcut

• Microsoft Office 2000 Developer, version 2000

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)

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:

Q236143 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.

Additional query words: prb

Keywords : kbdta accwfdesigner
Version : :2000
Platform : WINDOWS
Issue type : kbprb