ACC: "Out of Memory" Error Message Converting a Large Database (153035)


The information in this article applies to:

  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
This article was previously published under Q153035

SYMPTOMS

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you convert a large database from Microsoft Access version 2.0 to Microsoft Access 7.0 or Microsoft Access 97, you may receive an "Out of Memory" error message.

CAUSE

Visual Basic for Applications has a limitation of 1082 modules per database (mdb). Forms and reports each contain one module.

RESOLUTION

Reduce the number of objects in your database. Consider dividing your application into multiple databases. If you have modules with a lot of code, consider using library databases to store the code.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 7.0 and Microsoft Access 97.

REFERENCES

For more information about using library databases, search for "Library Databases," and then "Set a Reference to a Visual Basic Project in Another Microsoft Access Database" using the Microsoft Access 97 Help Index.
Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kbbug kberrmsg KB153035
©2003 Microsoft Corporation. All rights reserved.