Orphaned Class Module and 'Not enough memory' issue

A database that I have been working on appears to have run aground unfortunately I cant seem to get it back on track and it appears to be corrupted some what.

I removed 2 forms, but it appears that there class modules are still there when you access the vba console. When you then click on these modules you get the error message file not开发者_如何学运维 found.

I cant find any way to remove these modules.

At the same time as this issue arose I started having a problem with a form; when I try to open it in either design or form mode it wont open and I get an error message saying that it cant be opened and that I should try closing other applications. Tried closing other applications but this has not resolved the issue.

I tried creating a new database and importing all of the desired forms, modules etc (excluding the aforementioned class modules) but I cant import the above form. An error message keeps appearing as stated earlier.

Does anyone have any ideas on a fix for this, and a way to avoid this issue in the future?

All advice greatly appreciated.

Noel

Your two main sources for dealing with corruption are:

http://www.granite.ab.ca/access/corruptmdbs.htm
http://allenbrowne.com/ser-47.html

In this case, I would pay particular attention to /Decompile.