Debuger does not stop at breakpoint

Question

Access 2007

I set a breakpoint in a subroutine and the execution of source code does not stop at that breakpoint. Execution continues as if breakpoint is not there. I can tell by having a MsgBox with a unique message after the breakpoint.

I have done a Compact and Repair, Decompile, and other desparate acts. This seems almost impossible to believe. Why me?

Ted Palmer

Answer 1

Allen Browne,

Thank you for your help. I had a question on Experts Exchange (EE) that wasn't getting me a solution. But I got one from there this morning. I bookmarked your recovery procedure. I did something similar to that from a suggestion on EE, but it was not as well documented. Basicly /decompile and Compact & Repair. There is a link above to that question if you are interested.

The solution that actually worked for me on this problem was to create a blank database then import all the database objects from the DB that wasn't working. The debugger started stopping on my breakpoints after that.

Thank you

Ted Palmer

Answer 2

This may help or not - one other reason for breakpoints not pausing is if you go into Access Options for the Current Database and have unchecked the USE ACCESS SPECIAL KEYS checkbox (which you normally uncheck if you don't want F11 to work for users).  If you uncheck it then it will not break on set breakpoints.

Answer 3

Shane,

I should have also said that I verified that the code with the breakpoint is being executed by using a MsgBox with a unique string in it.

Answer 4

Shane,

I do not have a on error resume next statement. I do have an "On Error GoTo Err_Handler" statement. In the Err_Handler label I have "Resume Exit_Sub".

Answer 5

Do you have an on error resume next statement in your code?

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire