OFF97: How to Configure Setup.stf to Exclude Microsoft Access

• Microsoft Office 97 for Windows
• Microsoft Office 97 for Windows, Service Release 1 (SR-1)

SUMMARY

In Microsoft Office 97, it is possible to customize a post-administrative installation (setup /a) so that when your users run Office 97 Setup, Microsoft Access is not available for installation and none of the Microsoft Access components are installed.

This article explains how to perform this task by editing the Office Setup .stf file.

MORE INFORMATION

WARNING: This modification may not be supported by Microsoft. Microsoft support engineers will support some modifications to a BACKUP copy of the Setup.stf file. Note also that while support engineers may help customers modify specific lines of an STF, we will not rewrite the entire file in order to achieve a desired configuration. As a general rule, support is limited to options that can normally be changed by a user during a standard installation of the application.

NOTE: The following steps work only if you first perform an administrative installation (setup /a) of Office 97 to a server on your network. If you are performing a stand-alone installation using the Office 97 compact disc, you cannot use the steps in this article.

Before you perform the following steps, make a backup copy of the Off97pro.stf file on your server. Rename the file to Backup.stf and do not open or edit it for any reason.

NOTE: The following steps explain how to use Microsoft Excel to edit the .stf file. If Microsoft Excel is not installed or you have problems using these steps, open the .stf file in WordPad or another text editor that does not alter tabs and spaces. Make the appropriate changes outlined in step 15 and save the file.

To edit the .stf file in Microsoft Excel 5.0 or later, use the following steps:

1. In Microsoft Excel, open the .stf file you want to edit.

2. In the Text Import Wizard dialog box, click Next twice to proceed to step 3.

3. In the Text Import Wizard - Step 3 Of 3 dialog box, under Data Preview, drag the vertical scroll bar indicator down until the Object ID item appears in the Data Preview window. Click the first column to select it. Hold the SHIFT key down, and drag the horizontal scroll bar indicator to the right until the last column is displayed in the Data Preview window. Click the last column. All of the columns (at least 15 columns) should be selected.

4. Under Column Data Format, click the Text option, and click Finish.

5. After the .stf file is open, press CTRL+SHIFT+SPACEBAR to select the entire .stf file. Then, on the Data menu, point to Filter, and click AutoFilter.

6. In cell E1, click the arrow, and then click the value "AddRegData."

7. In cell F1, click the arrow and click Custom. In the Custom AutoFilter dialog box, set the following values

   Show rows where: F contains """" (four quotation marks)

   and click OK.

8. Select all visible cells in column F.

9. On the Edit menu, click Replace. In the Find What box, type a space, followed by a quotation mark ( "). In the Replace With box, type a quotation mark ("). Click Replace All.

10. Select all visible cells in column F.

11. On the Edit menu, click Replace. In the Find What box, type three quotation marks ("""). In the Replace With box, type two quotation marks (""). Click Replace All.

12. Select all visible cells in column F.

13. On the Edit menu, click Replace. In the Find What box, type two quotation marks (""). In the Replace With box, type a quotation mark ("). Click Replace All.

14. On the Data menu, point to Filter, and click AutoFilter.

15. Find the following Object IDs located in column A and delete the corresponding values from the Object Data column in column F. Make sure you delete the trailing space after each number. Use the table that is appropriate for your version of Office.

    Microsoft Office 97 Professional Edition:

           For        Remove the Reference to
           ----------------------------------
    
           ObjId 46                       118
           ObjId 52                       174
           ObjId 53                       117
           ObjId 54                       118
           ObjId 56                       120
           ObjId 57                       174
           ObjId 58                       117
           ObjId 59                       118
           ObjId 60                       119
           ObjId 62                       118
           ObjId 8836                    9001
    
        Microsoft Office 97 Professional Edition, SR-1:
    
           For        Remove the Reference to
           ----------------------------------
    
           ObjId 46                       131
           ObjId 53                       187
           ObjId 54                       130
           ObjId 55                       131
           ObjId 57                       133
           ObjId 58                       187
           ObjId 59                       130
           ObjId 60                       131
           ObjId 61                       132
           ObjId 63                       131
           ObjId 9036                    9201
    
    

       For        Remove the Reference to
       ----------------------------------

       ObjId 43                       124
       ObjId 50                       180
       ObjId 51                       123
       ObjId 52                       124
       ObjId 54                       126
       ObjId 55                       180
       ObjId 56                       123
       ObjId 57                       124
       ObjId 58                       125
       ObjId 60                       124
       ObjId 9036                    9301