VBA code does not work when using accde file

[oracle8202]

Does anybody know why all vba code would stop working after converting an
Access 2007 accdb file to accde format? I have looked around for several
hours but I cannot find out why this would be. It appears from Microsoft’s
help topics that the code is compiled and un-editable but should still run.
I have added the directory containing the accde file to my trusted
directories but this does not work. Anybody have any ideas on how to fix
this? Thank you.

 

[oracle8202]

Thank you for your reply. I sure did. I have found some threads mentioning
this issue but I have not found any that had a solution.

 

[oracle8202]

Just an update, out of desperation I have tried signing the database with a
certificate and I have tried disabling the sandbox. Neither have worked.

 

[oracle8202]

Okay I have finally figured it out. You have to choose "Debug->Compile" from
the VBA editor and then create the accde file. I found the solutions on the
threads below.

http://www.tek-tips.com/viewthread.cfm?qid=1482768&page=2

http://www.utteraccess.com/forums/showflat.php?Cat=&Number=1444593&page=&view=&sb=5&o=&vc=1