Knowledge Base

ACC2: Microsoft Access 2.0 Wizards Use More Global Memory Space

Article ID: 114166

Article Last Modified on 11/6/2000


APPLIES TO


This article was previously published under Q114166

SUMMARY

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

The Microsoft Access Wizards in Microsoft Access version 2.0 require 12% more global memory space than they do in version 1.x. In version 1.x the Wizards require 13% of total global memory; in version 2.0 they require 25%.

Because the Wizards require more global memory in version 2.0, large applications that use many global variables and have several Wizards loaded, may run out of global memory space, resulting in "Out of Memory" error messages.

NOTE: This behavior does not occur in Microsoft Access version 7.0.

MORE INFORMATION

To avoid running out of global memory space, try the following tips:
  • Uninstall some (or all) of the Wizards.
  • Whenever possible, use locally-scoped, instead of global, variables.
  • Use private functions in form or report modules, rather than using global modules.

REFERENCES

For more information about global variables, search for "Global," and then "Global Statement" using the Microsoft Access Help menu.

Additional query words: programming oom

Keywords: kbinfo kbusage KB114166