VB codes were gone.

[Glen17]

Good day everyone!

Iam working with a access with tables, queries, forms and report. I open the system last friday and it is good when I left it. But today (monday), I opened the system an error occured saying "Form.SampleForm subform can't open" but still I clicked 'Okay' but I when I look at the 'View Code' ALL CODES WERE GONE . I dont know what to do. Please help me with this :banghead:
Any reply is much appreciated! Thank you!

 

[Galaxiom]

Go back to your Friday backup.

 

[Glen17]

I dont have a friday back up

 

[Galaxiom]

Have you tried a compact and repair?

Another option would be a decompile but that is usually for corrupted code rather than missing code.

Try importing all objects into a new database.

If all else fails you could try this service.
http://www.everythingaccess.com/accessdatabaserepair_info.asp

 

[missinglinq]

Have you actually tried running one of the forms that is supposed to have code behind it? If you find that code is, in fact, running, in the IDE (code window) the Procedure View button has probably been activated. At or near the bottom of the code window, just to the left of the Horizontal Scroll Bars, are two tiny icons, Procedure View and Full Module View. Click on the Full Module View icon and see if your code reappears.

Linq ;0)>

 

[gemma-the-husky]

it's a bit "shutting the stable door", but I think we can't stress too much the importance of backing up your database to avoid too much loss after a crash. I am sure we have all had them.

not quite the same thing, but split your database as well. Keep the code separate from the data.