Microsoft KB Archive/153035

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

Article ID: 153035

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



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.

