Article ID: 159793
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q159793
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
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:
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.
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:
159322 ACC97: Paradox, Lotus, & MS Exchange/Outlook ISAMs in ValuPack
NOTE: If the Paradox file is the only file that needs to be installed, you can run Setup of Dataacc.exe, select the Custom option, and include just the Paradox driver to get this file properly installed on your computer.
Installing a Driver in Microsoft Access 97
To install a driver in Microsoft Access 97, follow these steps:
- Insert the Microsoft Access 97 or Microsoft Office 97, Professional Edition compact disc or floppy disk in the appropriate drive on your computer.
- Follow these steps to start the Setup program.
In Microsoft Windows 95 or Microsoft Windows NT version 4.0:
- Click the Start button on the taskbar, point to Settings, and then click Control Panel.
- In Control Panel, double-click the Add/Remove Programs icon.
- In the Add/Remove Programs Properties dialog box, click the Install/Uninstall tab.
- Select Microsoft Access 97 or Microsoft Office 97, Professional Edition, and then click Add/Remove.
In Microsoft Windows NT version 3.51:
- In File Manager or Program Manager, click Run on the File menu.
- 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. - Click OK.
- In the Setup Maintenance dialog box, click Add/Remove.
- Select Data Access, and then click Change Option.
- Select Database Drivers, and then click Change Option.
- Click the drivers you want to install, and then click OK.
- Click OK, and then click Continue, and follow the instructions on your screen to complete the setup of the driver.
- 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.
Additional query words: fail 1 2 3 123 import export can t load mspdox35 dll
Keywords: kberrmsg kbprb kbsetup KB159793