Help and Support
 

powered byLive Search

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

Article ID:310937
Last Review:March 26, 2007
Revision:7.1
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).

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.

Back to the top

RESOLUTION

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

Back to the top

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"

Back to the top

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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/161983/) ACC: Regsvr32a.exe Available in Download Center
11.Start Access 2002 or later, and then open the Access 97 database again.

Back to the top


APPLIES TO
Microsoft Office Access 2007
Microsoft Office Access 2003
Microsoft Access 2002 Standard Edition

Back to the top

Keywords: 
kbconversion kbopenfile kberrmsg kbprb KB310937

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.