Microsoft KB Archive/169658

= ACC97: Setup Error 914 After Modifying STF File =

Article ID: 169658

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q169658



Moderate: Requires basic macro, coding, and interoperability skills.



SYMPTOMS
When you run the Microsoft Access 97 Setup program from an administrative installation on a server, you may receive the following error message:

Setup Error 914

Object 27

Your Setup files may be damaged. Try restarting the Setup program from where you originally ran it.

You may also receive error messages regarding Objects 1932, 1933, 1934 and 3314. Finally, you receive the error message:

Microsoft Access 97 Setup was not completed successfully.



CAUSE
Microsoft Access 97 Setup is using a setup table (.stf) file that was opened, edited, and saved improperly in Microsoft Excel. The resulting corruption in the setup table can occur regardless of which version of Microsoft Excel you use to edit the file.

Also, if you open a custom .stf file in Microsoft Excel, make changes to it and save it, you may receive these error messages when you use the custom .stf file with Microsoft Access 97 Setup.



WORKAROUND
To prevent corruption of the setup table, you must perform extra steps immediately after opening the .stf file and prior to making any other changes to it.

 Open the .stf file. You can open the .stf file by following the steps in the following article in the Microsoft Knowledge Base:

178330 How to install Access 97 wizards locally [Standalone network setup]

 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. In cell E1, click the arrow, and then click the value "AddRegData."  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.  Select all visible cells in column F. On the Edit menu, click Replace. In the Find What box, type a single space followed by a quotation mark ( "). In the Replace With box, type a quotation mark ("). Click Replace All.</li> Select all visible cells in column F. 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.</li> Select all visible cells in column F. 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.</li> On the Data menu, point to Filter, and click AutoFilter. Locate ObjID 27 in column A.</li> Go to column G. Remove the leading space and the quotation marks surrounding the data in this cell.</li></ol>

You can now make changes to the .stf file. When you are finished, use the instructions shown in the Microsoft Knowledge Base article mentioned in step 1 and save the .stf file as a tab-delimited text file.

If you have already made changes to your .stf file and are receiving the error messages shown in the "Symptoms" section, you can repair your .stf file by following the steps in the "Workaround" section.

<div class="moreinformation_section">

MORE INFORMATION
When you open an .stf in Microsoft Excel, the Text Import Wizard helps you convert the file (a very large text file) into a format that Microsoft Excel can display.

The steps used to open an .stf in earlier versions of Microsoft Access must be altered slightly to work correctly with the setup table files for Microsoft Access 97. Because of this, using the incorrect steps to open, edit, and save the setup table file will result in a corrupted setup table file, and you will receive the error messages shown in the "Symptoms" section when you run Microsoft Access 97 Setup.

<div class="references_section">