Help! VBA Recovery

[marimambo]

I was working on a database I've been building and the program crashed. It errored a few times trying to start back up, so I quit and restarted the program. Now I've lost all my VBA code. Is anyone familiar with this? Is there any way to recover the code? Thankfully I backed it up to an external last night, but I've lost about 5 hours worth of work because of this. At the very least, is there any way to import my old code back in so I can at least keep the changes to the tables and forms themselves?

Thanks

-Sam

 

[marimambo]

Oh, quick note, the two errors I remember when it started up was that a form could not be loaded (I was in the process of deleting it when the program crashed), and then it said that it couldn't load the VBA Project. It's not erroring anymore. The code's just not there. I was able to read the code the first time I started it after the crash, but not anymore. I'm wishing I had the forethought to copy it all first before exiting.

 

[c_smithwick]

Happens to me more often than I would like. Only way to prevent code loss is to compile and save frequently and when you have a module completed, export it so you can reimport it into a new database if you are forced to start over.