Access VBA pauses at a line that used to have a breakpoint

Access VBA pauses at a line that used to have a breakpoint.  The line turns yellow, but there's no red indicating a breakpoint.  When I click the "run" arrow, it continues.

I've cleared all breakpoints.  I also made a copy, and that does it, too.  How do I make it stop stopping?
Barry SweezeySoftware EngineerAsked:
Who is Participating?
 
mbizupCommented:
Try cutting the offending line and pasting it back to the same place.

I've seen breakpoints refuse to clear occasionally - not sure what causes it, but deleting/reentering the line seems to do the trick for me.
0
 
Dale FyeCommented:
1. back up

2. After clearing all breakpoints, try a compact and repair.

3. It that still doesn't work, try decompiling and recompiling the database.  I usually do this via a batch file on my desktop (do it once or twice a week for the app I'm working on at the time).

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Users\xxx.yyy\Documents\Work\Access\myDb.accdb" /decompile

The stuff in the first set of quotes is the full path and filename where your version of Access resides (probably not Office12 from your post).  The second is the full path and filename of your database file.

Then do another compact/repair operation and then recompile.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
VBA is notorious for phantom breakpoints.  Copy the line to notepade, delete it.  Do a compile.  Close and then compact and repair the DB, then re-open and paste the line back in.  Then compile and save.

 That usually gets rid of it.

Jim.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
BTW, sometimes just adding a line or two, then doing a clear all breakpoints will take care of it to.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Believe it or not ...  Reboot your system ... done. Gone.

mx
0
 
Dale FyeCommented:
A little extreme, don't you think, Joe?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<A little extreme, don't you think, Joe?>>

  Maybe, but from where I sit, Windows needs a reboot as soon as it gets started....

 Actually I'll take that back...Windows 7 is a lot more stable then past versions were and it seems pretty solid even without reboots.

 Interesting though that a reboot would take care of it.  Never knew that.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"A little extreme, don't you think, Joe?"

Nooooo ... because that's what it takes.

mx
0
 
Barry SweezeySoftware EngineerAuthor Commented:
I deleted the line, compiled, reinserted the line, and compiled again.  It runs without stopping now.  Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.