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"

Article translations Article translations
Article ID: 926712 - View products that this article applies to.
Expand all | Collapse all

On This Page

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.

Properties

Article ID: 926712 - Last Review: October 15, 2007 - Revision: 1.3
APPLIES TO
  • Microsoft Office Access 2007
Keywords: 
kberrmsg kbinfo kbtshoot kbprb kbexpertiseinter KB926712

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com