ACC2: Microsoft Access 2.0 Wizards Use More Global Memory Space

• Microsoft Access version 2.0

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.