Entire VBA Code Disappeared - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Entire VBA Code Disappeared

Caleb Hansen

3 years ago

I was working on my project and everything was going well. After 4 months of working tirelessly on it I was finally getting to the point where I was inputting real data and tweaking things as I went along. Polishing up the look of my forms. Then this morning I open it up and click a button on my MainMenuF and it says "The Database cannot be opened because the VBA project contained in it cannot be read......" I open up Code Builder and it's completely empty. Everything disappeared. Please tell me it's not all gone. Anybody have any idea? I have older backups. The front end and my data is still all the current version, but I'd like to not have to go back through all my code from the backups if I can avoid it. And I'd certainly like to avoid this in the future. I did just update to Windows 11. Maybe that's playing a part in this?

	John Davy @Reply 3 years ago
Hi Caleb, Not sure whether this will help but I use a free utility "Everything". I suggest typing the name of your Project and see if anything shows up.

Caleb Hansen OP @Reply

3 years ago

I'm not having trouble finding the file. It opens up fine. But all of the code disappeared. I'm almost finished getting the code back to where it was but now I'm having trouble saving design changes to my reports. Forms tables and queries will save but not reports. Something weird is going on. I did a compact and repair and that didn't change anything. Still can't save design changes on reports. I'm thinking that perhaps a recent update is causing this bug, but I can't be sure

	Richard Rost @Reply 3 years ago
Troubleshooter

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View