Problems with Debugger

[crhodus]

At one time I had a breakpoint next to an IF THEN statement. Before I copied my program out to production for my users, I removed this breakpoint.

Sometimes when the user is using a form, the Visual Basic editor will launch and the IF THEN statement will be highlighted in Yellow (along with the yellow arrow on the far left side). I don't receive any type of error message when this happens. I can click F8 and continue to run each line of code successfully without any error message appearing.

I clicked on Debug -> Clear All Breakpoints, but this does not seem to solve the problem. (Note: there is no red dot on the left hand side signifying a breakpoint) I also tried to add a breakpoint where the program stop and then removed it to see if the debugger would stop being launched but this didn't work.

Can any tell me what's going on?

Thanks!
Crhodus

 

[WayneRyan]

Hi cr,

Access has a habit of going "brain dead". For some unknown reason, it may
still remember your breakpoint. You can do a:

Tools --> Database Utilities --> Compact/Repair

And it might help, but there is a Tools --> Options ?????

There is an option somewhere that won't let users "debug" code.

I'll look and let you know ...

Wayne

 

[crhodus]

I tried using the compact and repair option, but the breakpoint problem still occured. I ended up removing the code and then saving the form. I then went back into the form and pasted the vb code back into my button onClick event. So far, the breakpoint problem has not occured agian.