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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeOwner, Developing Solutions LLCCommented:
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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

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 Architect / Systems AnalystCommented:
Believe it or not ...  Reboot your system ... done. Gone.

mx
0
Dale FyeOwner, Developing Solutions LLCCommented:
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 Architect / Systems AnalystCommented:
"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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.