Chris This happened to me a week or two ago... Only thing I could do was try to copy the code back in but it kept happening so I created a new db, copied all the objects back in (forms, queries, reports, tables) and then copy all the code back in I could from a previous back up and recreate the rest.

Then after that, be ever vigilant with backups, because it kept doing it. I had to Rollback Access to get it to stop. Something just kept corrupting the DB.

If you figure anything else out, let me know please, so I can turn updates back on, lol.

Please start using VCS / GitHub
One for backups and two as it's easier to see and search for your code

Chris

I don't use VCS or GitHub.

When working with Access... you should have 2 files.  The Front End File and the Back End File.

You should always have backup copies of both of these files.

Before I make any changes to the Front End File, I change the name to add the date.  Then make the changes.  After I make the changes I make a backup of the updated version.  Now I have the last working version, my updated version, and a backup of my updated version.  (my previous versions had backups as well)

I typically don't need to make too many changes to my back-end, but I do this same process when making changes.

Besides making changes, I typically will make backups of the back-end... once/week.

==============================================================

If I have a problem with my Front-End file... I can restore it with the backup without losing any of the data.

I've not had any problems with my Back-End files, but if I did... I would only lose data from the last backup.

-Raymond

Sorry to keep bothering,

Access crashed on me, and I lost all the VBA Codes and modules. I can't seem to get them back; I have to re-code everything. I attempted to recode the VBA and revise some of the forms. Now I can't save the DB. I click save, then close, I get a pop-up to save, I click yes, but it doesn't save. When I click close, it does it again.
I tried to copy everything to a new DB, but I get an error "Name conflicts with existing module, project, or object library", and "the Microsoft Access database engine could not find the object" referring to the form I'm trying to copy to a new DB.

Any suggestions? other than building the DB from scratch, which seems to be the only thing I'm able to do.
I was hoping that if I repaired and reinstalled office it would fix the issue, but no luck.

Troubleshooter