I have an "app' that's built in Access that has been running for about a year now and has gone through 13 revisions (additions, updates).
This morning I added a form that uses an existing query and button to open that form on another form. It tested fine, so I relinked the tables to the server back end.
Now, every time I touch code, Access crashes. Whether by opening a module in design view, or by opening a form in design view and then viewing code, or opening a form that calls code, Access crashes - complete App Level crash with the error reporting and all.
Fortunately, yours is not a common situation, and I'm not surprised that nobody else experienced it. I would have suggested to use the undocumented Application.SaveAsText method to export the objects, then use the Application.LoadFromText method to re-import them, but this can't work if you cannot open the VBA editor at all.
Assuming the problem was corruption in a module that the regular "repair" didn't see (it has a class module - does the compact and repair miss those?)
I did this to fix it:
1) Copy and paste to a new location
2) Rename it
3) Open in bypass <these steps trigger the "You need to click to Enable Content" warning>
4) Remove the icon
5) Remove the startup form option
6) Close (close after each step that leaves it open)
7) Run the command line option /decompile
9) Run the command line option /compact
10) Run the command line option /repair
11) Copy and paste (just to make a quick backup in the new state)
12) Open, enable content and set the icon and startup form
Not really sure why it works, but certainly not complaining!