Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

You receive a "You can't convert or enable an MDE file" error message when you try to open or convert an Access 97 MDE file in Access 2000


View products that this article applies to.

Symptoms

When you use Microsoft Access 2000 to open or convert an MDE file created with Microsoft Access 97, you may receive the following error message:
You can't convert or enable an MDE file.

↑ Back to the top


Cause

An MDE file is a database in which all Visual Basic modules are stored in a compiled state and from which the source code has been removed. Because the source code has been removed, you cannot edit the design of forms, reports, or modules in an MDE database.

↑ Back to the top


Resolution

Convert the original Microsoft Access 97 database to a Microsoft Access 2000 database, and then create an Access 2000 MDE file from the converted MDB file. The newly created Access 2000 MDE file can no longer be opened in Access 97.

↑ Back to the top


More information

Microsoft Access 2000 uses a different method for storing a database's Visual Basic for Applications project than was used in earlier versions. In order to use databases created in earlier versions of Microsoft Access, the database's Visual Basic for Applications project must be converted or enabled in Microsoft Access 2000. However, because the source code for an MDE file has been removed, and because an MDE file cannot lose its compiled state, Microsoft Access 2000 cannot convert or enable the database.

Steps to Reproduce Behavior

  1. Use Microsoft Access 97 to open the sample database Northwind.mdb that ships with Access 97.
  2. On the Tools menu, point to Database Utilities, and click Make MDE File.
  3. Click Save in the Save MDE As dialog box.
  4. Close Microsoft Access 97 and open Northwind.mde in Microsoft Access 2000.
  5. When prompted to convert/open the database, click Open Database, and click OK.
Note that you receive the error message described in the "Symptoms" section .

↑ Back to the top


Keywords: KB216163, kbopenfile, kbprb, kbconversion, kberrmsg

↑ Back to the top

Article Info
Article ID : 216163
Revision : 5
Created on : 11/18/2004
Published on : 11/18/2004
Exists online : False
Views : 339