How to Delete VBA Module

[tgwacker]

I created and saved a non-class VBA module by mistake. I tried doing a Remove Module, but it still exists in the list of modules. Now when I first get into the Microsoft Visual Basic or update another module to add a new Sub, I get a message box saying 'File Not Found'. When I shut down Access, then get back in, the deleted module still exists in the list of modules. How can I get rid of this module and the message?

[June7]

Sounds like corruption. Have you tried Compact and Repair? If that doesn't fix, might have to import everything into a new db.

[tgwacker]

Compact and Repair did not work. I am resorting to importing into new table.