Cannot open or convert an Access 97 or Access 2000 database in Access 2002, in Access 2003, or in Access 2007

Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access database (.aacdb or .mdb)This article applies only to a Microsoft Access database (.mdb).


Symptoms

When you try to open a Microsoft Access 97 or Access 2000 database in Access 2002, in Microsoft Office Access 2003, or inMicrosoft Office Access 2007, you may receive one of the following error messages:

Cannot open a database created with a previous version of your application.
-OR-

Cannot open database PathToDatabase It may not be a database that your application recognizes, or the file may be corrupt.
When you try to convert an Access 2002 or later database into the Access 97 file format, you may receive the following error message:

Couldnot find installable ISAM.

Resolution

To resolve this behavior, use one of the following methods.

Method 1: Reregister the Dao360.dll file and the Msrd3x40.dll file

To reregister these files, follow these steps:
  1. Click Start, and then click
    Run.
  2. Type regsvr32 followed by the path to your DAO file. Enclose this path in quotation marks.

    For example, to register the DAO 3.6 library, use the following command:

    regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"

    If the Dao360.dll file is successfully registered, you receive a message that is similar to the following message:
    DllRegisterServer in C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll succeeded.
  3. Repeat step 2 to register the Msrd3x40.dll file by using the following command.
    regsvr32 "c:\WINDOWS\system32\msrd3x40.dll"

Method 2: Restore the correct registry settings

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows
  1. Quit Microsoft Access if it is running.
  2. Start Registry Editor (Regedit.exe).
  3. Locate the following key in the registry:
    HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\ISAM Formats
  4. Right-click ISAM Formats, point to New, and then click Key.
  5. Rename the newly created key Jet 3.x.
  6. Click to open the Jet 3.x key, and then insert the following values in the right pane of Registry Editor:

    Value Name Type Data
    ----------------------------------------------------------
    CreateDBOnExport REG_BINARY 00
    Engine REG_SZ Jet 3.x
    IndexDialog REG_BINARY 00
    IsamType REG_DWORD 0x00000000 (0)
    OneTablePerFile REG_BINARY 00
  7. Quit Registry Editor.
  8. Verify that both Regsvr32.exe and Msrd3x40.dll are in your Windows\System folder.
  9. Click Start, and then click Run.
  10. In the Run dialog box, type the following command:
    Regsvr32.exe C:\Winnt\System32\Msrd3x40.dll
    NOTE: The path to Msrd3x40.dll may be different on your computer, depending on which folder Windows in.

    For additional information about how to obtain Regsvr32.exe if you do not have it, click the following article number to view the article in the Microsoft Knowledge Base:
    161983 ACC: Regsvr32a.exe Available in Download Center

  11. Start Access 2002 or later, and then open the Access 97 database again.
Properties

Article ID: 310937 - Last Review: Oct 30, 2008 - Revision: 1

Feedback