Lost all Visual Basic Code for database

[Thorson]

Yesterday when I opened the front end of my database it gave me an error, It
is not coming up now so I can't remember it completely, but it said something
like "VBA is not readable save a backup copy and click ok to delete all VBA"
Of course I didn't want to delete it all, so I tried clicking cancel and it
wouldn't let me. I then made a back up copy and clicked ok, all my visual
basic code was gone.

The back up copy of the front end of the database also had the same problem.
I therefore closed out of both, tried re-opening, tried opening the back end
and then opening the front end again.

None of my code is visible, it looks like it was all deleted. I do have an
older backup copy that I can use if there is no other solution. Does anyone
know what might have caused this problem?

Thanks for your help.

 

[Klatuu]

Most likely it is caused by database corruption. First, try a decomplie and
a compact and repair.

If you still can't get it, delete the VBA, and move the code from the
working copy to the database. The best way to do that is to open the forms
and reports in design mode, open the code module, copy and paste from the
working version.

 

[Thorson]

Thank you, I will do that.
--
Thorson

Most likely it is caused by database corruption. First, try a decomplie and
a compact and repair.

If you still can't get it, delete the VBA, and move the code from the
working copy to the database. The best way to do that is to open the forms
and reports in design mode, open the code module, copy and paste from the
working version.