2007 looses VBA Code when trust center location not added

[BillieGoat]

I'm using 2 PCs. Both Vista. My 2nd PC seems to have corrupted my database
and lost the VBA code when I tried to open it without setting the location in
the trust center. Once it can't find the VBA the database seems to be
corrupted. I can't get it to work again. Switchboard doesn't work, none of
the buttons work. Anything that uses a module or code doesn't work.
It also did the same thing at a client who is running on Windows XP so the
problem seems to be in Access. I can see where it would ask you if you want
to run the database but this is corrupted now.

 

[Arvin Meyer [MVP]]

Try setting the Macro Security to Low:

Tools >>> Macro >>> Security

Then build a Trusted Location and set the security back on if you like.