ACC97: Removing/Adding Wizards Fails to Create ISAM Registry Key

• Microsoft Access 97
• Microsoft Office 97 Developer Edition

SYMPTOMS

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

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)

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:

   ARTICLE-ID: Q159322
   TITLE     : ACC97: Paradox, Lotus, & MS Exchange/Outlook ISAMs in
               ValuPack

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

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.

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:

       a. On the Windows Start menu, click Run.
   

       b. Enter the following command line (assuming the CD-ROM is d:\):
   

             D:\ setup /y
   
          and then click OK.
   
       c. In the first Office setup dialog box, click Reinstall.
   
       d. Click to Restart Windows at the end of the Microsoft Office
          setup program.
   
   

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you remove the Microsoft Access 97 Wizards, some of the file types 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 recreate the Windows registry keys that allow you to import, export, or link to certain file types.

Steps to Reproduce 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:

       a. Select Microsoft Access, and then click Change Option.
   

       b. Click to clear the check boxes for Wizards and Advanced Wizards.
   

       c. Click OK.
   

       d. Click Continue.
   

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

       a. Click to clear the check boxes for Wizards and Advanced Wizards.
   

       b. 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.