I am working on Access 2016. At times, when I try to open a database, I get a "program not responding" error. The vba modules of code still appear to be in the database, but they will not open. When I try to open one, I get a message "The module name (name of module) is misspelled or refers to a module that doesn't exist".
I have also gotten this message when trying to open the database: "The VBA modules in this database appear to have been saved with errors. Access can recover the modules, but you should backup the database first."
I have to go back to a backup copy of the program to resume use.
Does anyone know what could be causing the corruption?
Thanks for any help anyone can give.