PRB: Visual InterDev Data Connection Reports "Can't Find Installable ISAM" Error (268860)

SYMPTOMS

When you try to connect to an Access database with the Visual Interdev Data View Window, you may receive the following error message:

Can't Find Installable ISAM.

You may also receive the following error message intermittently:

Error Type:
Provider (0x80004005)
Unspecified error
/Project/page.asp, line xx

CAUSE

This problem occurs when you use an Access 2000 database that has been converted from an Access 97 database. Msrd2x32.dll is the ISAM driver that Microsoft Jet uses to read an earlier version of an Access database. The error occurs because this driver is not registered on the Web server, or the Internet Guest account (which is usually IUSR_ComputerName or IWAM_ComputerName if running out-of-process or with application protection set to high or medium) does not have read and execute permissions to this DLL.

RESOLUTION

To resolve this problem, you can do one of two things:

Register Msrd2x32.dll on the Web server, and then give the Internet Guest account read and execute permissions to this DLL. To do this, perform the following steps:
1. On the Start menu, click Run, and then type the following command:
  regsvr32 "C:\Winnt\System32\Msrd2x32.dll"
  Click OK.
2. The following message appears:
  DllRegisterServer in msrd2x32.dll succeeded.
  Click OK.
3. In Windows Explorer, browse to the C:\Winnt\System32 folder.
4. Right-click Msrd2x32.dll, and then click Properties on the shortcut menu.
5. On the Security tab, select the Read/Execute check box to give the Internet Guest account read and execute permissions.
Create a new Access 2000 database. You can import data into the new Access 2000 database from your existing Access 97 database, but you must not allow Access 2000 to upgrade it.

REFERENCES

For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:

209805 ACC2000: "Could Not Find Installable ISAM" Error Message

150494 ACC2: Troubleshooting "Can't Find Installable ISAM" Error

90111 ACC: "Couldn't Find Installable ISAM" Error Message

240377 HOWTO: Insure Jet 3.5 Is Installed Correctly (Part I)