Access xp - Why does debugger break in when I have no breakpoint .

Becker@discussions.microsoft.com DJ Becker

unread,

Feb 26, 2005, 11:45:03 AM2/26/05

to

I've made a change to an app that's been running for years. After adding
some code, now the debugger breaks in at a particular line even though I have
no breakpoint set there - I've Cleared All Breakpoints from the Debug menu.
If I click continue, the app continues without error. I need this code to
keep running - the users will not know what to do and shouldn't have to deal
with it anyway. Any ideas?

Ken Snell [MVP]

unread,

Feb 26, 2005, 12:38:14 PM2/26/05

to

VBE sometimes remembers "phantom" breakpoints.

Two ways that I use to fix this problem.

(1) Comment out the line on which the breakpoint occurs. If the code won't
compile without that line, then comment out a block of code so that the code
can compile without it. Compile the code. Close the database. Open the
database. Uncomment out the code. Compile the code.

(2) Use the undocumented decompile switch when opening the database so that
all compiled code is uncompiled.
"PathToAccessExecutable\msaccess.exe" /decompile
"PathToYourDataBaseFile\DatabaseFileName.mdb"

--

Ken Snell
<MS ACCESS MVP>

"DJ Becker" <DJ Bec...@discussions.microsoft.com> wrote in message
news:DA0E9301-0716-4E1E...@microsoft.com...

Becker@discussions.microsoft.com DJ Becker

unread,

Feb 26, 2005, 12:55:02 PM2/26/05

to

Beautiful - worked like a charm - Thanks.

I guess my frustration was inhibiting my ability to think of a simple
solution like that - I guess I expect a debugger to HELP me rather than get
in the way. Silly me.

This is my first post here and I have to say the answer appeared LOTS
quicker than it ever would have from searching the knowledge base. I imagine
I'll be back.

Thanks again.

-- Don --

Jeff Conrad

unread,

Feb 26, 2005, 1:03:52 PM2/26/05

to

"DJ Becker" <DJ Bec...@discussions.microsoft.com> wrote in message
news:DA0E9301-0716-4E1E...@microsoft.com...

> I've made a change to an app that's been running for years. After adding

Here is a past post by Gunny on this issue:
>>>>>

Sounds like the debugger settings were saved the last time a break point was
set at that line of code. You can open and close the database repeatedly,
and the problem remains.

To fix it, open the database, then open the form in Form View. Press
<ALT><F11> to open the VB Editor. Click the "Reset" button on the toolbar
three times. (Answer to question I know you are going to ask: Because
sometimes twice just isn't enough.) Select the Debug menu -> Compile
<DatabaseName>, just in case the code wasn't already compiled.

Press <ALT><Q> to return to Access. Select the Tools menu -> Database
Utilities -> Compact and Repair Database to compact the database. When
finished, close the database. Open the database again and open the form in
Form View, then enter text into the field that has recently been causing the
problem. The problem should be gone because you've removed the ghost
breakpoint.

And next time you are stepping through code, don't make any changes to the
code. That's what causes the ghost breakpoints.

HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
>>>>>

Good luck,
--
Jeff Conrad
Access Junkie
Bend, Oregon

Ken Snell [MVP]

unread,

Feb 26, 2005, 2:46:15 PM2/26/05

to

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

"DJ Becker" <DJ Bec...@discussions.microsoft.com> wrote in message

news:829A5C64-05E0-4EED...@microsoft.com...

David C. Holley

unread,

Feb 27, 2005, 9:23:04 AM2/27/05

to

Q: When I click the RESET button three times, is there anything special
I need to say like "I wish I were home", "Bill Gates is god", "Please,
oh baby, please work for daddy"

David H

Jeff Conrad

unread,

Feb 27, 2005, 1:10:04 PM2/27/05

to

"Dirk Goldgar" <d...@NOdataSPAMgnostics.com> wrote in message
news:O4k8D1OH...@TK2MSFTNGP15.phx.gbl...

> No, but you do have to put $5 in an envelope and send it to Gunny's Home
> for Wayward Programmers.

Is that tax deductible?
I could use a few more deductions.

Dirk Goldgar

unread,

Feb 27, 2005, 11:57:56 AM2/27/05

to

"David C. Holley" <DavidC...@netscape.net> wrote in message
news:O1ELbfNH...@tk2msftngp13.phx.gbl

> Q: When I click the RESET button three times, is there anything
> special I need to say like "I wish I were home", "Bill Gates is god",
> "Please, oh baby, please work for daddy"

No, but you do have to put $5 in an envelope and send it to Gunny's Home
for Wayward Programmers.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Dirk Goldgar

unread,

Feb 27, 2005, 2:28:58 PM2/27/05

to

"Jeff Conrad" <je...@ernstbrothers.com> wrote in message
news:emw96dPH...@TK2MSFTNGP12.phx.gbl

> "Dirk Goldgar" <d...@NOdataSPAMgnostics.com> wrote in message
> news:O4k8D1OH...@TK2MSFTNGP15.phx.gbl...
>
>> No, but you do have to put $5 in an envelope and send it to Gunny's
>> Home for Wayward Programmers.
>
> Is that tax deductible?
> I could use a few more deductions.

That's between you and the IRS. Don't let me stand in your way.

JDRaven

unread,

Feb 28, 2008, 4:34:00 AM2/28/08

to

2 years later, and this post just helped me resolve a problem that cropped up
today with an Access database somebody else wrote. Your post has withstood
the test of time.

Thanks!

Robert Morley

unread,

Feb 28, 2008, 12:26:06 PM2/28/08

to

Another common method is to set and clear a breakpoint on the line that has
the phantom breakpoint. I've had fairly good luck with that method so far,
and it's nice and quick.

Rob

JDRaven

unread,

Feb 28, 2008, 12:49:00 PM2/28/08

to

Thanks. I tried that first, and it did not resolve my particular problem.

And thanks for not pointing out my basic math miscalc: the original post was
3 years old and not 2 ;o)

Have a great day!