PRB: "Could not load the setup or translator library" JET ODBC Error on Windows Millennium Edition (295000)

SYMPTOMS

When creating an ODBC data source name (DSN) to a Microsoft Access database on a Windows Millennium Edition (Me) computer, the following error messages may result:

The setup routines for the Microsoft Access Driver (*.mdb) ODBC driver could not be loaded due to system error code 31.

Could not load the setup or translator library.

CAUSE

This problem can be caused by the upgrade process from Windows 98 to Windows Me. If the Jet 4.0 SP3 package or later Jet versions (including MDAC 2.5 SP1) are installed on a Windows 98 computer and the computer is then upgraded to Windows Me, the upgrade process incorrectly replaces files needed for ODBC Jet functionality. Specifically, an older version of the Mswstr10.dll file is installed, and this older version does not work with the newer version of Odbcjt32.dll that is installed with the later Jet packages.

RESOLUTION

At this time, the only resolution is to restart Windows Me in Safe mode and then manually replace the Mswstr10.dll file in the Windows\System directory with version 4.0.3829.2 or later.

If this problem has occurred as a result of the upgrade scenario described above, the desired version of Mswstr10.dll will be located in the Windows\VCM folder after the upgrade. You can simply copy this file into Windows\System folder while in Safe mode.

Otherwise, you will need to obtain this file from the Jet 4.0 SP3 package or later service packs of Jet, or from MDAC 2.5 SP1. Please note that the install routines for these packages will not upgrade the file correctly. You need to manually copy these files out of the self-extracting install packages and then place them in the appropriate folder while the computer is in Safe mode. (The files must be copied in Safe mode to circumvent Windows System File Protection.)