MS Access Out of Memory Error

[jeffshex]

This one is puzzling me.
When ever an action happens (button click or anything that has VBA in it), an error message pops up and all it says is "Out of Memory".
I have tried increasing page file size, and the jet registry for allocated memory and no luck there either.

Anyone have any good suggestions as to why this all of the sudden started happening?

 

[JoeAtWork]

Do you keep a lot of VBA modules open? They suck up memory.

 

[Remou]

This may help:

Sub CloseAllCodeWindows()
Dim i

For i = VBE.CodePanes.Count To 1 Step -1
    VBE.CodePanes(i).Window.Close
Next
End Sub

 

[jeffshex]

I think that file has just corrupted on itself. I can't even type/paste that code in there Remou.
I had a backup that is working ok - so I will just have to run with that.
That error started coming up right after Access said it had to close and restart itself.
Thanks for the ideas.

 

[Remou]

Best go through the whole corrupt routine with the back-up, just to be safe, that is, decompile (

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

compact & repair, and copy eveything to a fresh DB.