Access XP--"Make MDE File" Option Not Available

Sunday, March 03, 2002 08:13:28
home

This was dervice from Microsoft Knowledge Article Q278376

This article applies to a Microsoft Access database (.mdb) and 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.