Database Corrupted?

[darkstar257]

I have issues opening a 2003 Access database today where it says one of the forms couldn't be opened and clicking through the prompts brought me into the VB editor window showing the form's class object code page..however it was BLANK. Completely blank... all the many pages of coding mysteriously vanished.

The form itself still exists in the Database window, but it can't be opened. However, I can click Design and open the design view of it and see that the entire form is still there intact with all fields, buttons, texts, etc.

How might this have happened?

 

[GinaWhipp]

Sounds like the beginning of corruption...
http://www.granite.ab.ca/access/corruption/symptoms.htm
I would make a back-up, make another back-up and then first try importing everything into a new database. Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm
And after all of that I would finish off with this article…
http://allenbrowne.com/ser-25.html and see if any of those circumstances apply to you.
And when all else fails…
Data Recovery Services (I have never used them but I see them most mentioned when trying to recover data)…
http://www.pksolutions.com/t4.htm