Out of Memory Error in Access 2002

A

Alex @ DCX

I have a large Microsoft Access database running on a server with as many as
80 users at a time. Users run an mde file locally. The tables are linked
from a seperate access mdb file. My PC has less than 512MB RAM.

I am encountering "Out of Memory (Error 7)" errors in the design views of
forms and reports, as well as in the VB modules. There are approximately 75
form and report modules, which I have gone through and verified that I am not
using global variables. All are locally dimmed. When I try to delete subs,
add buttons, and even edit code, I get this error message and changes are not
accepted.

I have reviewed Microsoft.com and verified I am running the correct service
packs.

Anyone have any ideas or corrections?
 
A

Alex @ DCX

Cont....

When I try to rename an existing module, I receive an error: "There isn't
enough memory to complete the Automation object operation on the | object.
 
Top