Ms Access: Switches to debug mode with no error
by Edwin on Apr.15, 2009, under MsOffice, Software
From time to time it happens: Ms Access goes into debug mode without an error. Saving, recompiling, compact/repair, nothing seems to cure the problem. The problem keeps on coming back at the same piece of code.
What seems to happen is that you can’t erase a breakpoint that you’ve created before. Somehow you need to decompile the code.
A very easy workaround is cut the code subroutine/function where it keeps on breaking, press save and paste the code again. Save and compile the code again. Ms Access will no longer go into debug mode!
Cheers,
Edwin
May 5th, 2009 on 6:12 pm
Thanks for the hint. I was thinking of something along this line, but your suggestion worked perfectly.
Steve
May 6th, 2009 on 8:59 am
Hi, interesting post. I have been thinking about this topic,so thanks for blogging. I’ll definitely be coming back to your site. Keep up the good work
October 12th, 2009 on 9:54 pm
Some corruption can cause this, and compact/repair alone may not resolve the problem.
Instead, decompile the program as follows (using full paths):
For MS-Access 2002:
“C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE” / DECOMPILE “C:\My MSAccess Program Folder\MyMSAccessProgram.mdb”
For MS-Access 2007:
“C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE” / DECOMPILE “C:\My MSAccess Program Folder\MyMSAccessProgram.mdb”
Afterward, the program file will also probably be much smaller. The DECOMPILE will remove old code versions of code that is no longer needed, and possibly causing errors (such as ERROR # 49; Bad DLL calling convention; or MS-Access jumping into DEBUG mode for no known reason).
October 15th, 2009 on 10:34 am
what are the codes of switches in debug mode