Article ID: 236534
Article Last Modified on 7/30/2001
APPLIES TO
- Microsoft Office 2000 Developer Edition
This article was previously published under Q236534
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
No matter what you specify for the Start In property in the Package and Deployment Wizard, the Start In property of a non-Access shortcut is always set to the folder location of the target file. Also, the Start In property of any shortcuts to Access databases always defaults to the folder where Msaccess.exe is located.
CAUSE
In the Package and Deployment Wizard, the page named Start Menu Items allows you to add and make changes to shortcuts that are installed by the package. However, the option for Start In is ignored. For non-Access shortcuts, it is always the folder location of the target file. For Access solutions, it is set to the folder where Msaccess.exe is located.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce Behavior
- In Access, create a new database called MyDatabase.mdb.
NOTE: For this demonstration, it is not necessary to create any objects in the database. - Open Microsoft Excel, create a new workbook called MyWorkbook.xls, and then save the workbook.
- On the Tools menu, point to Macro, and then click Visual Basic Editor.
- On the Add-ins menu, click Package and Deployment Wizard.
If the Package and Deployment Wizard command is not available on the Add-ins menu, see the following article in the Microsoft Knowledge Base about how to load the wizard:Q236143 MOD2000: How to Start the Package and Deployment Wizard
- In the Package and Deployment Wizard, click Package.
- Click Next on each page and accept the defaults until you see the page titled Package and Deployment Wizard - Included Files.
- Click to select the Include Access Runtime check box. (If you are prompted for the location of the Access Runtime files, you can find them on the Office Developer 2000 CD under \ODEtools\V9\AccessRT.)
- Click Add, and then add the MyDatabase.mdb file to the package.
- Click Next.
- On the Installation Options page, change Installation Title to MyTest.
- Click Next to move to the Package and Deployment Wizard - Start Menu Items page.
- Change the Start In field for MyWorkbook to $(CommonFiles). Click OK.
NOTE: $(CommonFiles) is a Setup macro that resolves the path to the location of the Common Files folder. - Click New Item.
- In the Start Menu Item Properties dialog box, type the following properties:
NOTE: $(WinPath) is a Setup macro that resolves the path to where Windows 95/98 or Windows NT is installed.
Name: MyDatabase
Target: MyDatabase.mdb
Start In: $(WinPath) - Click OK, and then continue to click Next (accept all the defaults) until the wizard is finished.
- On a clean computer (a computer that has a newly installed version of Windows and no other applications), run Setup for the newly create package.
- When Setup is finished, click Properties on the taskbar.
- Click Start Menu Programs, and then click Advanced. Windows Explorer opens at the Start Menu folder.
- Click the Start Menu folder, click the Programs folder, and then click MyTest.
- Click the MyWorkbook shortcut, and then on the File menu, click Properties.
- Note that Start In does not have the path to the Common Files folder. It has the path to the folder where MyWorkbook.xls is located.
- Close the properties for the MyWorkbook shortcut, and then view the properties for the MyDatabase shortcut.
- Note that for the MyDatabase shortcut, the Start In property is set to the folder where Msaccess.exe is located, not to the path where Windows or Windows NT is installed.
Additional query words: pra can t
Keywords: kbbug kbpdwizard kbpending KB236534
