Microsoft KB Archive/160954: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - """ to """)
Line 110: Line 110:
=== Method 2: Maintenance Mode Setup and Setup /y ===
=== Method 2: Maintenance Mode Setup and Setup /y ===


Add the wizards again by running the Setup program in Maintenance Mode. Then, run the Setup program a second time using the command line switch of "setup /y" to add the missing Registry key.
Add the wizards again by running the Setup program in Maintenance Mode. Then, run the Setup program a second time using the command line switch of "setup /y" to add the missing Registry key.
<ol>
<ol>
<li>Run setup from the CD that installed Microsoft Access. This should start Maintenance Mode setup.</li>
<li>Run setup from the CD that installed Microsoft Access. This should start Maintenance Mode setup.</li>
Line 133: Line 133:
<div class="indent">
<div class="indent">


[[../155666|155666]] ACC: Troubleshoot &quot;Couldn't Find Installable ISAM&quot; Error
[[../155666|155666]] ACC: Troubleshoot "Couldn't Find Installable ISAM" Error





Revision as of 09:14, 21 July 2020

Article ID: 160954

Article Last Modified on 1/19/2007



APPLIES TO

  • Microsoft Access 97 Standard Edition
  • Microsoft Office 97 Developer Edition



This article was previously published under Q160954

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


SYMPTOMS

When you run the Microsoft Access 97 or Microsoft Office 97 Professional Edition Setup program to remove the Microsoft Access 97 Wizards, Setup also removes the following options to import, export, or link to certain file types:

   Action           File Types Removed
   -----------------------------------------------------
   Import           Microsoft Excel (*.xls)
                    Text Files (*.txt;*.csv;*.tab;*.asc)
                    HTML Documents (*.html;*.htm)
                    Lotus 1-2-3 (*.wk*)

   Link             Microsoft Excel (*.xls)
                    Text Files (*.txt;*.csv;*.tab;*.asc)
                    HTML Documents (*.html;*.htm)

   Save As/Export   Microsoft Excel 5-7 (*.xls)
                    Microsoft Excel 4 (*.xls)
                    Microsoft Excel 3 (*.xls)
                    Microsoft Excel 97 (*.xls)
                    Text Files (*.txt;*.csv;*.tab;*.asc)
                

If you run Setup and reinstall the Microsoft Access 97 wizards, the missing import, export, and link file types are not restored.

NOTE: The Lotus 1-2-3 indexed sequential access method (ISAM) driver is included in the Microsoft Office 97 ValuPack. For more information about the drivers included in the ValuPack, please see the following article in the Microsoft Knowledge Base:

159322 ACC97: Paradox, Lotus, & MS Exchange/Outlook ISAMs in ValuPack


CAUSE

When you remove the Microsoft Access 97 Wizards, some of the file types that you can import, export, or link are removed also because they require wizards. When you run Setup to reinstall the Microsoft Access 97 Wizards, the Setup program restores the wizard files, but it does not re-create the registry keys that allow you to import, export, or link to certain file types.

RESOLUTION

There are two possible methods for resolving this problem:

  • Rename the Setup.stf file and reinstall Microsoft Access


-or-

  • Add the Wizards with Maintenance Mode Setup, and then run Setup again using a command line switch of /y

The following two sections describe each of these methods in detail.

Method 1: Renaming the Setup.stf and Reinstalling

To resolve this error and restore the missing options, rename your program's setup information file, and then reinstall:

  • For Microsoft Office 97 Professional edition, rename the Off97Pro.stf file, and then reinstall Microsoft Office 97 from the original media.
  • For the Microsoft Access 97 stand-alone program, rename the Acc97.stf file, and then reinstall Microsoft Access 97 from the original media.

The setup information files are located in the C:\Program Files\Microsoft Office\Office\Setup folder by default.

If you installed the Lotus 1-2-3 ISAM driver, you must also rerun Setup for the Data Access Pack, and then reinstall that driver.

Method 2: Maintenance Mode Setup and Setup /y

Add the wizards again by running the Setup program in Maintenance Mode. Then, run the Setup program a second time using the command line switch of "setup /y" to add the missing Registry key.

  1. Run setup from the CD that installed Microsoft Access. This should start Maintenance Mode setup.
  2. In the first Office setup dialog box, Click Add/Remove.
  3. In the second Office setup dialog box, click Access in the list, and then click the Change Options button.
  4. Click to select the Wizards and Advanced Wizards check boxes in the third Office setup dialog box, and then click OK.
  5. Click Continue to add the wizards again, and then click the Restart Windows option.
  6. Using the same CD that you used originally to install Microsoft Access, run Setup again by following these steps:
    1. On the Windows Start menu, click Run.
    2. Enter the following command line (assuming the CD-ROM is d:\):

                D:\ setup /y
                                  

      and then click OK.

    3. In the first Office setup dialog box, click Reinstall.
    4. Click to restart Windows at the end of the Microsoft Office setup program.

If you installed the Lotus 1-2-3 ISAM driver, you must also rerun Setup for the Data Access Pack, and then reinstall that driver.

NOTE: If these two methods do not resolve the issue, you may be experiencing a separate issue detailed in one of the following two articles: For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

155666 ACC: Troubleshoot "Couldn't Find Installable ISAM" Error


171955 ACC97: Certain ISAM Drivers Not Appearing in Files Of Type Box


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Problem

NOTE: Following these steps will require you to reinstall Microsoft Access 97 or Microsoft Office 97 Professional Edition from the original media. This example assumes that Microsoft Access 97 is already set up on your computer.

  1. Start the Microsoft Access 97 or Microsoft Office 97 Professional Edition Setup program.
  2. In the Maintenance Program dialog box, click Add/Remove.
  3. If you have Microsoft Office 97 Professional Edition:

    1. Select Microsoft Access, and then click Change Option.
    2. Click to clear the check boxes for Wizards and Advanced Wizards.
    3. Click OK.
    4. Click Continue.

    If you have the Microsoft Access 97 stand-alone program:

    1. Click to clear the check boxes for Wizards and Advanced Wizards.
    2. Click Continue.
  4. Click Yes in the Confirm Component Removal dialog box to confirm that you want to remove the wizards.
  5. When Setup finishes removing the files, repeat steps 1-3. This time select the Wizards and Advanced Wizards check boxes instead of clearing them.
  6. Start Microsoft Access 97 and open the sample database Northwind.mdb.
  7. On the File menu, point to Get External data, and then click Import.
  8. View the selections in the Files Of Type box. Note that Text, Microsoft Excel, Lotus 1-2-3, and HTML file types are not listed.



Additional query words: attach uninstall prb

Keywords: kbprb kbsetup KB160954