I've been modifying my Access forms and VBA code for years and haven't had this happen before, so I'm at a loss as to how to fix it. I updated a subroutine and the update tested just fine, so I attempted to make an .accde file with the new changes. Instead of creating the .accde file, however, Access totally crashed with the "Microsoft Access has stopped working - A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available." error message. At this point, all I can do is click on the Close Program button. When I re-opened the file, I went to Design View on the form I was modifying and clicked on the Event Procedure I was working on, but instead of opening the editor, it crashed again with the same message.
hinking that something in the update caused a problem (which I doubt, since all I did was add an If check to some existing code), I tried to open the backup .accdb file I saved off before I started making any changes. Access crashed again when trying to open the editor. I've tried completely shutting the system down in case something was being cached, but that didn't help either. As it stands, I no longer have any way to modify my application forms, and I really need to do that.
Something pretty drastic must have happened to Access itself, but I have no idea what. Any insights as to how to fix it will be greatly appreciated.