ACC97: How to Install Microsoft Access Wizards Locally Rather Than on a Network Server (174742)

MORE INFORMATION

The following is the text of Acwizard.doc.

WARNING: ANY USE BY YOU OF THE INFORMATION IN THIS ARTICLE IS AT YOUR OWN RISK. Microsoft provides this information "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. Modification of the Setup Table File (STF) is not supported by Microsoft Access Product Support professionals.

If you open, edit, and save the STF file improperly in Microsoft Excel, you may receive a "Setup Error 932" error message. To resolve this error, please see the following article in the Microsoft Knowledge Base:

162796 OFF97: Setup Error 932 After Modifying STF File

NOTE: To see references mentioned in the following text, please connect to the "Microsoft Office 97 Resource Kit" Web site at the following address:

http://www.microsoft.com/office/ork/

Modifying the STF File to Run Microsoft Access from the Network

To make a Run from Network Server installation from an administrative installation point work more smoothly, administrators can modify the Microsoft Office 97 Professional Edition or Microsoft Access 97 Setup Table File (STF). These modifications are described in the following sections.

--------------------------------------------------------------------------
WARNING: The modifications that are described in this paper should only be used with Run from Network Server installations. Do not use an STF file with these modifications for Typical or Custom installations.

To use a modified STF file to change a Run From Network Server installation, make a backup copy of the Setup.lst file (typically this file is located in the Msoffice folder of your administrative installation point), then open the file in Notepad and search and replace all occurrences of the names of STF and INF files with the names of the files you create using the procedures in this paper. Save the modified LST file to a name of your choosing. Then create a BAT file that uses a command- line in the following format to run Setup:

pathtosetup\Setup /l filename.lst /b3 /q1

These command-line options perform the following functions: /l points to the LST file that you modified to point to the correct STF and INF files for this installation, /b3 runs a Run from Network Server installation, and /q1 runs Setup in quiet mode.
--------------------------------------------------------------------------

Installing Microsoft Access Wizards Locally

After performing a Run from Network Server installation, Microsoft Access runs wizards directly from the Workdir folder on the network server. This works properly as long as users are given Change permissions (the set of Read, Write, Execute, and Delete permissions) in the Workdir folder, as described in "Creating the Administrative Installation Point" in Chapter 4, "Installing Microsoft Office," in the Microsoft Office 97 Resource Kit.

However, a user cannot run certain wizards, such as the Table Wizard, from the network if another user is running the same wizard at the same time. Instead, an error message is displayed. To avoid sharing conflicts when running wizards, or if you don't want to give users Change permissions in the Workdir folder, you can modify the STF file so that Setup installs Microsoft Access 97 wizard files on users' hard drives during Run from Network Server installations.

NOTE: The following instructions are recommended only for administrators who are familiar with administrative installations and editing of the STF file. All of the procedures in this paper assume that you have already created an administrative installation point. For more information, see "Creating the Administrative Installation Point" in Chapter 4, "Installing Microsoft Office," in the Microsoft Office 97 Resource Kit.

WARNING: Off97Pro.stf and Acc97.stf are tab-delimited files that rely heavily on positional parameters, and they can easily be damaged by modifying them using a method other than the one described here.

The best way to make complex edits to an STF file is by using Microsoft Excel. Microsoft Excel opens the tab-delimited data in an STF file as separate columns so that you can easily view and modify the data. However, if you do not follow the correct procedures when opening an STF file, you can damage the format of the STF file. Some of the tab characters used to delimit data in the STF files for Microsoft Office 97 and Microsoft Access 97 are followed by a single space. Before editing the STF file the first time in Microsoft Excel, you must remove these trailing spaces as described in the following procedure.

To remove trailing spaces from an STF file

Make a backup copy of the STF file (Off97pro.stf or Acc97.stf) in the MSOffice folder of the administrative installation point.
Open the STF file in Microsoft Word (version 6.0 or later).
On the Edit menu, click Replace.
In the Find What box, type ^t followed by a single space.
In the Replace With box, type ^t with no space following.
Click Replace All.
On the File menu, click Save As, and save the file as Text Only. Microsoft Word saves the file with a .txt extension.
In My Computer or Windows Explorer, rename the file to remove the .txt extension and restore its original name (Off97pro.stf or Acc97.stf).

After you remove any trailing spaces from the STF file, you can safely open it in Microsoft Excel and there is no need to repeat this procedure.

When you open an STF file in Microsoft Excel, it starts the Text Import Wizard to specify how data is formatted. You must make the correct selections in the Text Import Wizard to make sure that all columns of data in the file are opened using a Text format.

To open an STF file using Microsoft Excel

Before opening an STF file the first time, remove trailing spaces as described in the preceding procedure.
Start Microsoft Excel and open the STF file. The Text Import Wizard starts automatically.
Click Next twice to proceed to Step 3 of 3 in the wizard.
In the Data Preview window, scroll down until ObjID is displayed at the top of the first column.
Click the first column to select it.
Scroll all the way to the right until the last column is displayed. The data at the top of the last column should be Install Directory.
Hold down shift and click the last column. All of the columns in the Data Preview list should be selected.
In Column Data Format, click Text, and then click Finish.

Microsoft Excel opens the STF file. An STF file starts with about 30 rows of header information. Scroll down until you see ObjID in column A. This is the beginning of the STF table information that you will modify using the procedures that follow. You can adjust the widths of each column to view the data in each column better.

To modify the administrative installation point for Office 97 to install Microsoft Access wizards on users' hard drives

Open Off97pro.stf in Microsoft Excel as described earlier in this paper in the procedure "To open an STF file using Microsoft Excel."
Scroll down to the row that contains 120 in column A (ObjID ). In column F (Object Data ), change the value 147 to 148. The values in column F for this row should now read:
```
      124 121 148 150
						
```
Scroll down to the row that contains 121 in column A and delete the value 127 in column F. The value in column F should now read:
```
      126 592 123 141 131
						
```

Find the rows with the following values in column A and change the values in column K (Destination Directory) as specified in the following table.

    Column A  In column K, change this value     To this value
    ----------------------------------------------------------

    168       %d                                %148
    801       %d,%d\Office                      %148,%d\Office
    806       %s\Workdir,%d\Office              %148,%d\Office
    810       %d,%d\Office                      %148,%d\Office
    2098      %d,%d\Office                      %148,%d\Office
    2102      %d,%d\Office                      %148,%d\Office

Find the rows that contain 811 and 2099 in column A. For both rows, locate the string %s within the value in column F and change it to %148. The values in column F for each row should now read:

    Column A  Column F

    811       "LOCAL","Software\Microsoft\Office\8.0\Access\Wizards
              \Data Files", "Wizard Data File", "%148\wzdat80.mdt", ""
    2099      "LOCAL",
              "Software\Microsoft\Office\8.0\Access\Wizards\Replication
              Conflicts", "Path", "%148\Wzcnf80.mda", ""

If you make no other changes, Setup installs the wizard files on users' hard drives in the Program Files\Microsoft Office\Office folder. If you want to change the destination for the wizard files to some other shared Windows NT Server folder, such as a user's home directory, find the row that begins with 148 in column A and change the value in column K using the following format:

   driveletter:\foldername

For example, to create a Workdir folder in the shared network folder mapped to the user's H drive, enter H:\Workdir\. For this to work, every user who runs Setup using the modified STF file must have drive H mapped to a shared folder on the network and must have Change permissions for that folder.

Do not change anything else in the file. Save the file with the changes you made back to the MSOffice folder of the administrative installation point.

To modify the administrative installation point for Microsoft Access 97 to install Microsoft Access wizards on users' hard drives

Open Acc97pro.stf in Microsoft Excel as described earlier in this paper in the procedure "To open an STF file using Microsoft Excel."
Scroll down to the rows that contain 25 and 29 in column A. In column F (Object Data ), change the value 75 to 76 for both rows. The value in column F of both rows should now read:
```
      31 130 51 48 76 78
						
```
Scroll down to the row that contain 48 in column A. In column F, delete the value 54. The value in column F should now read:
```
      53 57 3411 333 50 59
						
```

Find the rows with the following values in column A and change the values in column K (Destination Directory) as specified in the following table.

    Column A  In column K, change this value      To this value
    -----------------------------------------------------------

    96        %d                                  %76
    397       %d,%d\Office                        %76,%d\Office
    406       %d,%d\Office                        %76,%d\Office
    407       %406                                %76
    595       %d,%d\Office                        %76,%d\Office
    599       %d,%d\Office                        %76,%d\Office

Find the row that contains 407 in column A. Locate the string %s within the value in column F and change it to %76. The value in column should now read:
```
      "LOCAL", "Software\Microsoft\Office\8.0\Access\Wizards\Data Files",
      "Wizard Data File", "%76\wzdat80.mdt", ""
						
```

If you make no other changes, Setup installs the wizard files on users' hard drives in the Program Files\Microsoft Office\Office folder. If you want to change the destination for the wizard files to some other shared Windows NT Server folder, such as a user's home directory, find the row that contains 76 in column A and change the value in column K using the following format:

   driveletter:\foldername

Sharing the Same Workgroup Information File

The changes described in the previous section copy only Microsoft Access wizard files to users' hard drives. The workgroup information file, System.mdw, remains in the Workdir folder on the network server and is shared by all users who run Microsoft Access from network. This arrangement works as long as all users running Microsoft Access from the network have at least read permissions and have the same level of security permissions for the Workdir folder.

If a user needs to add or modify Microsoft Access user-level security account information (which is stored in the System.mdw file), that user must log on with at least Change permissions. However, if a user logs on with Change permissions or higher while other users have only Read or Add & Read permissions, problems can occur. For example, if a user with Change permissions starts Microsoft Access when no other users are running Microsoft Access, the System.mdw file is opened for exclusive access, and no other users can open the file or start Microsoft Access. You can avoid this problem any of four ways:

If no users need to make changes to user-level security account information, make sure all users who run Microsoft Access from the network have the same level of permissions in the Workdir folder.
If one user needs to change user-level security account information, have that user log on using an account that has Change permissions in the Workdir folder and then exit Microsoft Access as soon as the changes are finished.
Alternatively, if a user needs to change user-level security account information, have that user use the Workgroup Administrator or the /wrkgrp command-line option to specify a copy of the System.mdw in a different folder. After making changes to that System.mdw, the user can copy the modified file back into the Workdir folder after all other users have exited Microsoft Access.
You can modify the STF and INF files before users install Office 97 or Microsoft Access 97 so that Setup installs a copy of System.mdw in the Program Files\Microsoft Office\Office folder on users' hard drives during Run from Network Server installations, as described in the following procedures. In this scenario, if a user needs to change user- level security account information after Office 97 or Microsoft Access 97 has been installed, that user must distribute copies of the updated System.mdw file for other users to copy to their hard drives.

NOTE: The following instructions assume that you have already modified the STF file to copy wizard files locally, as described earlier in this paper.

To modify the administrative installation point for Office 97 to Install System.mdw on users' hard drives

Open Off97pro.stf in Microsoft Excel as described earlier in this paper in the procedure "To open an STF file using Microsoft Excel."
Scroll down to the row that contains 148 in column A. Add 561 to the end of the value in column F. The value in column F should now read:
```
      808 2097 2101 797 170 561
						
```
Scroll down to row that contains 561 in column A. In column E (Object Type), change the value from CustomAction to CopyFile. In column F, change the value from "msacccah.dll, SyncEXECalloutCAH, %s\OS\System\wrkgadm.exe /sil %s\Workdir\system.mdw" to User Files, system_mdw. The beginning of this row should now read:
```
      561        CopyFile User Files, system_mdw
						
```
Also, in the row that contains 561 in column A, add %148 in column K.
Scroll down to the rows that contain the values 2124 and 2143 in column A; change the value in column K for both rows to %148. The value in column K for both rows should now read:
```
      %148
						
```
Also, in the row that contains 2143 in column A; delete workdir\ from the value in column F. The value in column F should now read:
```
      "LOCAL", "Software\Microsoft\Office\8.0\Access\Jet\3.5\Engines",
      "SystemDB", "%s\system.mdw", ""
						
```

Do not change anything else in the file. Save the file with the changes you made back to the MSOffice folder of the administrative installation point.

The Off97pro.inf file also needs to be modified.

To modify the Off97pro.inf file

Make a backup of the Off97pro.inf file.
Open the file in WordPad or another text editor that does not alter tabs and spaces.
Search for system.mdw and insert Workdir\ in front of system.mdw. The line should now read:
```
       "system_mdw"= 1,Workdir\System.mdw,,,,,,,,,,,,,,,,,,,
						
```

Do not change anything else in the file. Save the file with the changes you made back to the MSOffice folder of the administrative installation point.

To modify the administrative installation point for Microsoft Access 97 to install System.mdw on users' hard drives

Open Acc97.stf in Microsoft Excel as described earlier in this paper in the procedure "To open an STF file using Microsoft Excel."
Scroll down to the rows that contain the values 25 and 29 in column A. In column F, change the value 78 to 80 for both rows. The values in column F for both rows should now read:
```
       31 130 51 48 76 80
						
```
Scroll down to the row that contains 76 in column A. Add 302 to the end of the value in column F. The value in column F should now read:
```
      404 594 598 393 98 302
						
```
Scroll down to the row that contains 302 in column A. In column E (Object Type), change the value from CustomAction to CopyFile. In column F, change the value from "msacccah.dll, SyncEXECalloutCAH, %s\OS\System\wrkgadm.exe /sil %s\Workdir\system.mdw" to User Files, system_mdw. The beginning of this row should now read:
```
       302        CopyFile User Files, system_mdw
						
```
Also, in the row that contains 302 in column A, add %76 in column K.
Scroll down to the rows that contain the values 2705 and 2726 in column A. Change the value in column K for both rows to %76. The value in column K for both rows should now read:
```
       %76
						
```
Also, in the rows that contain 2705 and 2726 in column A, locate the string %s within the value in column F and change it to %76. The value in column F for both rows should now read:
```
      "LOCAL", "Software\Microsoft\Office\8.0\Access\Wizards\Data Files",
      "Wizard Data File", "%76\wzdat80.mdt", ""
						
```

Do not change anything else in the file. Save the file with the changes you made back to the MSOffice folder of the administrative installation point.

The Acc97.inf file also needs to be modified.

To modify the Acc97.inf file

Make a backup of the Acc97.inf file.
Open the file in WordPad or another text editor that does not alter tabs and spaces.
Search for system.mdw and insert Workdir\ in front of system.mdw. The line should now read:
```
       "system_mdw"= 1,Workdir\System.mdw,,,,,,,,,,,,,,,,,,,
						
```

Do not change anything else in the file. Save the file with the changes you made back to the MSOffice folder of the administrative installation point.

For more information about installing the wizards locally, please see the following articles in the Microsoft Knowledge Base:

178331 How to Install Wizards Locally [OFF97 SR1 Network Install]

178330 ACC97: How to Install Wizards Locally [Standalone Network Setup]