Help! I need to fix this ASAP. When I try to open the
Design Master Replica database, I get message "Visual
Basic for Applications Project in database is corrupt."
The message window will not close and I cannot access the
modules or anything else. I have to close down with Task
Manager. Any ideas?
There is a "decompile" switch (available in Access 97, 2000, 2002 and, probably,
2003) that can be used to help correct this situation, but this is more of a
"last resort" in that there is some risk to the file as described in
http://www.trigeminal.com/usenet/usenet004.asp?1033 (so ... work with a copy of
the file). Further information is available at
http://www.databasecreations.com/DatabasePerformanceTips.pdf. The procedure I
use when implementing this is as follows:
1) BACK UP YOUR MDB FILE!
1) BACK UP YOUR MDB FILE! (I meant it the first time <g>)
2) Compact the MDB.
3) Implement the "/decompile" as described in the articles I referenced.
(Access 2000, and later, don't provide the confirmation dialog that
existed in Access 97, but the decompile will still take place.)
4) Open Access normally and compact the MDB again to clean up.
5) Compile and save.
6) Compact again before testing/using.
