ACC: Can't Open a Database Created with an Earlier Version

ID: Q152216

The information in this article applies to:

Microsoft Access versions 7.0, 97

SYMPTOMS

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

When you link a Microsoft Access 2.0 database (.mdb) file in Microsoft Access 7.0 or 97, you may receive the following error message:

Can't open a database created with a previous version of your application.

Similarly, if you use Visual Basic to link a Microsoft Access 2.0 .mdb file or if you open an application in Visual Basic that contains a link to a Microsoft Access 2.0 .mdb file, you may receive this error message.

This error message may also occur if you try to convert a database from an earlier version of Microsoft Access.

CAUSE

In Microsoft Access 7.0, the Microsoft Jet database engine version 2.x key is missing from the Windows Registry under the following key:


   HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.0\ISAM Formats

In Microsoft Access 97, the Microsoft Jet database engine version 2.x key is missing from the Windows Registry under the following key:


   HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\ISAM Formats

The 2.x key will be missing if you remove a run-time application created with the Microsoft Office 97 Developer Edition Tools (or Microsoft Access Developer's Toolkit for Microsoft Access 7.0). When you remove the application, the Microsoft Jet database engine version 2.x key is removed from the Windows Registry.

This registry setting is necessary for any application that uses the Jet 2.x ISAM driver to access a Jet 2.x table or query.

RESOLUTION

You can run Setup to reset the registry settings. To do so, follow these steps:

In Windows 95 or later, or Windows NT 4.0, click Start, and then click Run (or in Windows NT 3.51, click Run on the File menu in Program Manager or File Manager.)

Insert Disk 1 of the Microsoft Access 7.0 or 97 disks into a floppy drive on your computer. Or, insert the Microsoft Office 95 Professional CD or the Microsoft Office 97 Professional CD into the CD-ROM drive.

Type a command to run the Microsoft Access Setup program using the /y switch, for example:
```
      a:\setup /y 
```

In the Installation Maintenance Program box, click Reinstall. The Setup program updates the Windows Registry for Microsoft Access.

When Setup is complete, try starting Microsoft Access and linking the Microsoft Access 2.0 database file.

Keywords : kbenv kberrmsg
Version : 7.0 97
Platform : WINDOWS
Issue type : kbprb