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

 Last reviewed: May 14, 1997
Article ID: Q153035
The information in this article applies to:
  • Microsoft Access versions 7.0, 97

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 large amounts 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. We are researching this problem and will post new information here as it becomes available.

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.

Keywords : CnvNodb kberrmsg kbusage
Version : 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbbug
Resolution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.