ACC95: Unable to Create 32-Bit ODBC Data Source (150500)

RESOLUTION

IMPORTANT: The following resolution contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

For information about how to edit the registry, view the Changing Keys And Values online Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To resolve the problem, follow these steps:

1. Uninstall the Microsoft Desktop ODBC Drivers of Microsoft Access 7.0 by following these steps:
   
   
   1. In Windows 95, click the Start button, point to Settings, and then click Control Panel.
   2. In Control Panel, double-click Add/Remove Programs.
   3. In the Add/Remove Programs Properties dialog box, select Microsoft Access 7.0, and then click Add/Remove.
   4. In the Microsoft Access Setup box, click Add/Remove.
   5. In the Maintenance box, select the Data Access option, and then click Change Option.
   6. Deselect Microsoft Desktop ODBC Drivers and click OK and Continue. When asked to confirm the removal of the components, click Yes.
2. Remove any leftover keys in the Microsoft Registry from the installation of ODBC components by following these steps:
   
   
   1. Start the Registry Editor. To do so, click the Start button, click Run, and then type "regedit" (without the quotation marks) in the Run dialog box. Click OK.
   2. In the Registry Editor dialog box, locate the following key: HKEY_Local_Machine\Software\ODBC\Odbcinst.ini\SQL Server
   3. Select any keys listed under \SQL Server.
   4. On the File menu, click Delete. When asked to confirm the deletions, click Yes.
   5. Close the Registry Editor.
3. Reinstall the Microsoft Desktop ODBC Drivers in Microsoft Access 7.0 by following these steps:
   
   
   1. In Windows 95, click the Start button, point to Settings, and then click Control Panel.
   2. In Control Panel, double-click Add/Remove Programs.
   3. In the Add/Remove Programs Properties dialog box, select Microsoft Access 7.0, and then click Add/Remove.
   4. In the Microsoft Access Setup box, click Add/Remove.
   5. In the Maintenance box, select the Data Access option, and then click Change Option.
   6. Select Microsoft Desktop ODBC Drivers and click OK and Continue. If asked to confirm the installation, click Yes.