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

Article translations Article translations
Article ID: 310937 - View products that this article applies to.
This article was previously published under Q310937
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).

Expand all | Collapse all

On This Page

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: March 26, 2007 - Revision: 7.2
APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
Keywords: 
kbconversion kbopenfile kberrmsg kbprb KB310937

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com