How many memory needs Access and VBA screen

[checkOut]

I have no idea what Access needs for memory. When I try to open VBA editor. I get the message invaled memory space. EVEN when all programs close. Anybody can give an acceptable reason I can tell to my boss?

Thanx in advance,

Gerard

 

[PaulBricker]

Gerard, how much code do you have in the Database. If you are using A2000 and probably 2002, Access loads ALL the code modules when you open one and it drains memory like nothing I've ever seen. If you want a clear demonstration, open any Module. Then go to Window on the menu bar and look at all the modules you have open. If you have many, you will see a little "More Windows" dropdown list. It's quite unbelieveable. I have 256 on my home machine and when I have some of my test db's open, it's not enough.

Paul