Help and Support

Article ID: 283788 - Last Review: June 30, 2004 - Revision: 2.0

ACC2000: "Microsoft Access Was Unable to Create an MDE (or ADE) Database" Error Message with a Database That You Cannot Compile

View products that this article applies to.
This article was previously published under Q283788
Moderate: Requires basic macro, coding, and interoperability skills.

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

On This Page

Expand all | Collapse all

SYMPTOMS

When you try to save a Microsoft Access database as a MDE file, you may receive the following error message
Microsoft Access was unable to create an MDE database.
and the MDE file is not created.

When you try to save a Microsoft Access project as an ADE file, you may receive the following error message
Microsoft Access was unable to create an ADE database.
and the ADE file is not created.
Back to the top

CAUSE

You may receive this error message if either of the following is true:
  • There is an error in the Visual Basic for Applications code that prevents you from compiling the database or project.
  • There is a reference to an Access database (.mdb) or an Access project (.adp).
Back to the top

RESOLUTION

Correct any problems in the code that prevent you from compiling the database or project and remove any references to .mdb and .adp files. If you need to maintain a reference to a .mdb or .adp file, convert that file into an MDE or an ADE file, and then create a reference to the new file. You should now be able to convert the database or project to an MDE or an ADE file.
Back to the top

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Create a new database.
  2. Press ALT+F11 to open the Visual Basic Editor.
  3. On the Insert menu, click Module.
  4. Type the following code:
    Sub Generate_Compile_Error()
   MsgBoxx "This will cause an error"
End Sub
  5. On the File menu, click Save projectname.
  6. Press ALT+F11 to return to Microsoft Access.
  7. On the Tools menu, point to Database Utilities, and then click Make MDE File.

    Note that you receive the error message that is mentioned in the "Symptoms" section of this article.
Back to the top

REFERENCES

For additional information about other causes for this error message, click the article number below to view the article in the Microsoft Knowledge Base:
202304  (http://support.microsoft.com/kb/202304/EN-US/ ) ACC2000: "Microsoft Access Was Unable to Create an MDE Database" Error Message
Back to the top
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Back to the top
Keywords: 
kbprb KB283788
Back to the top

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

 

Related Support Centers