ACC97: How to Install Microsoft Access Wizards Locally Rather Than on a Network Server
ID: Q174742
|
The information in this article applies to:
SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article reproduces the text of Acwizard.doc, a Word document that
discusses how to modify the Setup Table File (STF) so that Setup installs
Microsoft Access 97 wizard files on users' hard drives during Run From
Network Server installations.
Acwizard.doc is one of nine advanced Office documents contained in
Document.exe, a downloadable file on the "Microsoft Office 97 Resource Kit
Tools and Utilities" page on the World Wide Web. To see a description of
the other Office documents or to download Document.exe, please see the
following Microsoft World Wide Web site:
http://http://www.microsoft.com/office/ork/appa/appa.htm#ORKappaC4
NOTE: Because the Microsoft Web site is constantly updated, the site
address may change without notice. If this occurs, link to the Microsoft
home page at the following address:
http://www.microsoft.com/
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:
Q162796 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
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.
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:
Q178331 How to Install Wizards Locally [OFF97 SR1 Network Install]
Q178330 ACC97: How to Install Wizards Locally [Standalone Network
Setup]
Additional query words:
inf
Keywords : StpNet
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbinfo
|