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.

Back to the top

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.

Back to the top

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.

Back to the top

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.

Back to the top