Out of Memory

[RADM]

Hi,

Whenever I am trying to open VBE, "Out of Memory" message is appearing. I have around 10-25 forms and that much of reports with tables and queries. If somebody can send me a solution, it will be helpful for me.


Regards,

Ramadas

 

[oharab]

I would try decompiling, compacting & repairing your database.

http://www.granite.ab.ca/access/decompile.htm

if that doesn't work, try opening the file on another PC or creating a new file and importing the objects in your old file into the new.

Good luck

Ben

----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"

NoFX-The Decline
----------------------------------------------

 

[PaulBricker]

You may indeed be out of memory if you are using A2000 or newer. In these versions, Microsoft changed the way it loads code modules (essentially to improve response time). In A97, it loaded only the modules needed. Now, it loads them ALL and they are memory hungry. You need to do some housekeeping. Make sure all your Object variables like
Dim db as DAO.Database
Dim rst as DAO.Recordset

are closed
Set rst = Nothing
Set db = Nothing

That will help. Also, the decompile will help.

Paul