You are currently offline, waiting for your internet to reconnect

Error message when you use Access 2003 to try to open an .mde file that you created in Access 2007: "This database is in an unrecognized format"

SYMPTOMS
You create a compiled database (.mde) file in the Access 2002-2003 database format in Microsoft Office Access 2007. When you use Microsoft Office Access 2003 to try to open the .mde file, you receive the following error message:
This database is in an unrecognized format.
The database may have been created with a later version of Microsoft Office Access than the one you are using. Upgrade your version of Microsoft Office Access to the current one, then open this database.
STATUS
This behavior is by design.
MORE INFORMATION
When you save a database as an .mde file, the .mde file compiles all modules, removes all editable source code, and then compacts the destination database. Visual Basic for Applications (VBA) code will continue to run. However, the VBA code cannot be viewed or edited. Because of the changes that Access 2007 makes to a database when the database is saved an .mde file, .mde files cannot be converted to a file format from an earlier version of Microsoft Access.

Steps to reproduce the behavior

  1. Start Access 2007.
  2. Click the Microsoft Office Button, and then click New.
  3. Click Blank Database, type DatabaseName in the File Name box, and then click Create.
  4. Click the Microsoft Office Button, click Save As, and then click Access 2002-2003 database.
  5. In the Microsoft Office Access dialog box, click Yes to confirm that you want Access 2007 to close the objects.
  6. In the Save As dialog box, type DatabaseName in the File Name box, and then click Save.
  7. On the Database Tools tab, click Make MDE.
  8. In the Save As dialog box, type DatabaseName in the File Name box, and then click Save.
  9. Start Access 2003.
  10. On the File menu, click Open.
  11. In the Open dialog box, locate the DatabaseName.mde file that you created in step 7, and then click Open.
  12. In the Security Warning dialog box, click Open.
AC2007 ACC2007 Access2007
Properties

Article ID: 926712 - Last Review: 10/15/2007 22:36:00 - Revision: 1.3

Microsoft Office Access 2007

  • kberrmsg kbinfo kbtshoot kbprb kbexpertiseinter KB926712
Feedback