ACC2000: "Microsoft Access Was Unable to Create an MDE Database" Error Message (202304)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q202304
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2002 version of this article, see 289686.

SYMPTOMS

When you try to save a Microsoft Access database as an MDE file, you may receive the following error message:
Can't open any more tables.
When you click OK, you receive the message:
Out of memory.
When you click OK again, you receive the message
Microsoft Access was unable to create an MDE database.
and the MDE file is not created.

CAUSE

The Microsoft Jet database engine version 4.0 allows a maximum of 2048 open TableIDs at one time. The process of saving a database as an MDE may cause this number to be exceeded if the database contains a large number of objects.

WORKAROUND

Use lightweight forms and reports whenever possible, or reduce the number of objects in the database.

MORE INFORMATION

There is no accurate method to estimate the number of TableIDs that the Jet database engine uses during the process of saving a particular database as an MDE. Each module uses one TableID, and saving the database as an MDE involves the Visual Basic for Applications project of the database as well as the project of the MDE. As a result, if your database contains 500 forms, and each form's HasModule property is set to Yes, you may use as many as 1000 TableIDs when saving the database as an MDE.

Steps to Reproduce Behavior

  1. Open a database containing a total of more than 700 forms and reports whose HasModule properties are set to Yes.
  2. On the Tools menu, point to Database Utilities, and then click Make MDE file.
  3. In the Save MDE As dialog box, click Save.

    Note that Microsoft Access tries to complete the process of saving the database as an MDE, but eventually you receive the error messages described in the "Symptoms" section.

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:

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

For more information about lightweight forms and reports, click Microsoft Access Help on the Help menu, type HasModule property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kberrmsg kbprb KB202304
©2004 Microsoft Corporation. All rights reserved.