Microsoft KB Archive/150063

= ADT/ODE: How to Use the Setup Wizard to Join Workgroup =

Article ID: 150063

Article Last Modified on 10/31/2003

-

APPLIES TO


 * Microsoft Access Developer's Toolkit 1.1
 * Microsoft Office 97 Developer Edition

-



This article was previously published under Q150063



Advanced: Requires expert coding, interoperability, and multiuser skills.



SUMMARY
This article describes how to join a run-time application to a workgroup file (SYSTEM.MDW) located on the network.



MORE INFORMATION
The following example demonstrates how to use the Microsoft Office 97 Developer Edition Tools (ODE) or the Microsoft Access Developer's Toolkit For Windows 95 (ADT) Setup Wizard to create a custom setup routine which joins a workgroup file (SYSTEM.MDW) on a network drive.  Start the ODE or ADT Setup Wizard. On the Introduction screen click "Create a new set of setup options...."  Click Next to move to the next screen which states:   Add the files that you want your custom Setup program to copy and then set properties for each file.  Click Add. Select the Northwind.mdb database, and then click Add. Click the "Set as Application's Main File" box.</li>  Click Next to move to the next screen which states: <pre class="fixed_text">  Add the shortcuts that you want your custom Setup program to create and then set the properties for each shortcut. </li> Click Add.</li> Type "Northwind Traders" (without the quotation marks) in the Description box.</li>  Make sure the File To Open box specifies the full path to the Northwind.mdb database, for example: <pre class="fixed_text">  C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb </li> Do one of the following.

In the Microsoft Office 97 Developer Edition Tools
On the General Shortcut Properties tab, click "I would like to specify my own custom command Line."

In the Microsoft Access Developer's Toolkit
Under Command-Line Style, click "Specify My Own Custom Command Line."

</li>  Clear the Command Line box and type the following <pre class="fixed_text">  "MSACCESS.EXE" /Runtime "$(FilePath)\NORTHWIND.MDB" /Wrkgrp \\SERVERNAME\SHARENAME\SYSTEM.MDW where SERVERNAME is the actual server name and SHARENAME is the path to the folder where the SYSTEM.MDW is located. (Make sure to type the quotation marks.)

NOTE: When using the Microsoft Access Developer's Toolkit for Windows 95, you must modify the command line to read as follows: <pre class="fixed_text">  "C:\Program Files\Common Files\Microsoft   Shared\Microsoft Access Runtime\MSACCESS.EXE" /Runtime "$(FilePath)\NORTHWIND.MDB" /Wrkgrp \\SERVERNAME\SHARENAME\SYSTEM.MDW where SERVERNAME is the actual server name and SHARENAME is the path to the folder where the SYSTEM.MDW is located. (Make sure to type the quotation marks.) </li> Click Next twice to move to the screen which states

In the Microsoft Office 97 Developer Edition Tools
<pre class="fixed_text">  You may now add redistributable Microsoft Office, Microsoft Jet, and ODBC components to your custom Setup program.

In the Microsoft Access Developer's Toolkit
<pre class="fixed_text">  Which of the following Microsoft Access components do you want your custom Setup program to include?

</li> Click Microsoft Access Run-Time Version and Workgroup Administrator.</li> Click Finish. When prompted to save the current Setup template, click No.</li></ol>

NOTE: When the run-time application is later installed, it will create a shortcut that will automatically point to the SYSTEM.MDW file on the network. To view this shortcut, click Start, go to Programs, and click Applications to locate the shortcut icon.

Keywords: kbhowto kbsetup KB150063

-

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

© Microsoft Corporation. All rights reserved.