"Make MDE File" or "Make ADE File" command is not available in Access 2002 (278376)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q278376
For a Microsoft Office Access 2003 version of this article, see 824273.
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

In an Access database (MDB) file or an Access project (ADP) file, you notice that the command to make an MDE or ADE file is not available on the Database Utilities menu on the Tools menu.

CAUSE

You are using an Access MDB or ADP file that was created in an earlier version of Microsoft Access, and the MDB or ADP file has not been converted to the Access 2002 format. Or, the MDB or ADP file was created in Access 2002 using the Access 2000 file format.

RESOLUTION

Convert the MDB of ADP file to the Access 2002 format. To do so, follow these steps:
  1. Start Access.
  2. On the Tools menu, point to Database Utilities, point to Convert Database, and then click To Access 2002 File Format.
  3. In the Database to Convert From dialog box, select your database, and then click Convert.
  4. In the Convert Database Into dialog box, specify the name of the new Access 2002 database, select the location where you want to store the new file, and then click Save.
  5. Click OK to complete the conversion.
  6. Open the newly created file. Note that the Make MDE File (or Make ADE File) command is now available on the Database Utilities menu on the Tools menu.

MORE INFORMATION

When creating an MDE or ADE file, Microsoft Access stores a copy of the current object model as a part of the compiled Visual Basic for Applications project. Because the Access 2002 object library contains new objects, methods, properties and events not recognized by earlier versions of Microsoft Access, Access 2002 will not be able to make an MDE or ADE file. Therefore, the option to make an MDE file or an ADE file in Access 2002 is disabled when the MDB or ADP is not in the Access 2002 file format.

Steps to Reproduce the Behavior

  1. Use Microsoft Access 2002 to open a database that was created in an earlier version of Microsoft Access and that has not been converted to Access 2002 format.
  2. On the Tools menu, point to Database Utilities. Note that the Make MDE File command is not available.
Modification Type:MajorLast Reviewed:8/10/2004
Keywords:kbconversion kbtshoot kbprb KB278376
©2004 Microsoft Corporation. All rights reserved.