Search code examples
vbams-accesscorrupt

Delete VBA module

I was deleting an Access Object (a report) and Access crashed during the delete.

The object no longer exists in Access, but its module still shows up in VBA like a ghost.

If I click on it, I get a FILE NOT FOUND error.

If I try to compact & repair or compile the database, I get a FILE NOT FOUND error.

How can I solve this problem?

Solution

  • A potential option is to create a new database file, and import all of the content from the old database file. that will clear out the funky ghost stuff.