ACC: "Can't Load Mspdox35.dll" Error Installing MS Access 95

• Microsoft Access versions 7.0, 97

SYMPTOMS

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

When you run Setup for Microsoft Access 7.0 on a computer that already has Microsoft Access 97 installed, you may receive one of the following pairs of error messages:

   Can't load mspdox35.dll (error code=1157)
   The configuration of the ODBC Microsoft Paradox Driver (*.db) driver
   failed.

   NOTE: The above error message has also been found to occur when you
   uninstall Microsoft Office 97 and reinstall Microsoft Office 95 or
   attempt to install Microsoft Office 95 after Microsoft Visual Studio
   has been installed.

   Can't load msxbse35.dll (error code=1157)
   The configuration of the ODBC Microsoft dBase Driver (*.dbf) driver
   failed.

   Can't load mstext35.dll (error code=1157)
   The configuration of the ODBC Microsoft Text Driver (*.txt; *.csv)
   driver failed.

   Can't load msexcl35.dll (error code=1157)
   The configuration of the ODBC Microsoft Excel Driver (*.xls) driver
   failed.

   Then you receive a message that Setup was not completed successfully.

   NOTE: The "Can't load mspdox35.dll (error code=1157)" error message was
   also found to occur while uninstalling Microsoft Office 95 after
   Microsoft Office 97 Professional Edition had already been installed.

CAUSE

You tried to install the Microsoft Access 7.0 driver for Paradox, dBASE, Microsoft FoxPro, Text, or Microsoft Excel, but you did not install the corresponding driver for Microsoft Access 97.

RESOLUTION

You must rerun Setup for Microsoft Access 97 to install the same drivers that you are trying to install in Microsoft Access 7.0.

NOTE: The Paradox ISAM driver, along with the Lotus 1-2-3 and Microsoft Exchange/Outlook ISAM drivers, are not included in the Setup program for Microsoft Access 97 or Microsoft Office 97 Professional Edition. They are included as part of the Microsoft Office 97 ValuPack.

If the files in the Valupack folder are the only files that need to be reinstalled, you do not need to rerun Setup of Microsoft Access. You can run Setup for Dataacc.exe and select the Custom option to install the drivers in the ValuPack folder.

For information about obtaining and installing these drivers, please see the following article in the Microsoft Knowledge Base:

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

Installing a Driver in Microsoft Access 97

To install a driver in Microsoft Access 97, follow these steps:

1. Insert the Microsoft Access 97 or Microsoft Office 97, Professional Edition compact disc or floppy disk in the appropriate drive on your computer.

2. Follow these steps to start the Setup program.

   In Microsoft Windows 95 or Microsoft Windows NT version 4.0:

       a. Click the Start button on the taskbar, point to Settings, and then
          click Control Panel.
   

       b. In Control Panel, double-click the Add/Remove Programs icon.
   

       c. In the Add/Remove Programs Properties dialog box, click the
          Install/Uninstall tab.
   

       d. Select Microsoft Access 97 or Microsoft Office 97, Professional
          Edition, and then click Add/Remove.
   

   In Microsoft Windows NT version 3.51:

       a. In File Manager or Program Manager, click Run on the File menu.
   

       b. Type the following command in the Command Line box:
   

            <drive>:\setup.exe
   
          where <drive> is the CD-ROM or disk drive letter that contains
          your compact disc or floppy disk.
   
       c. Click OK.
   
   

3. In the Setup Maintenance dialog box, click Add/Remove.

4. Select Data Access, and then click Change Option.

5. Select Database Drivers, and then click Change Option.

6. Click the drivers you want to install, and then click OK.

7. Click OK, and then click Continue, and follow the instructions on your screen to complete the setup of the driver.

8. Start the Setup program for Microsoft Access 7.0 and repeat your original installation steps.

MORE INFORMATION

You can set up and run more than one version of Microsoft Access on a single computer. However, the Setup program for Microsoft Access 97 installs a new version of the ODBC administrator, ODBC version 3.0, that looks for and expects Microsoft Access 97 drivers. If you run Setup for Microsoft Access 7.0 and try to load an earlier version of a driver before you load the Microsoft Access 97 version, you receive an error message.

REFERENCES

For more information about the interaction between 32-bit ISAM drivers and ODBC 3.0, search the Help Index in the ODBC Microsoft Desktop Database Drivers Help file for "Overview." You must have the Odbcjet.hlp Help file installed on your computer to view this Help topic.