Program still stops where F9 was (how do I fix it)

[DougP]

I had a stop (by pressing F9 or clicking the side bar). It has been gone for days now but it continues to stop there when there is no red line anymore.
I've run into this before and it went a way when I click Tools -> Database Utilities -> Compact and repair. This time that does not work.

It still stops, I compact and repair again but it continues to stop when no Red line is there.
It stops even when I first start the program meaning that no Stop points are present. I have clicked Clear all breakpoints but it continues to stop.
Any Ideas?


DougP

 

[PHV]

You may try to cut the line and paste it.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[RobertT687]

Try decompiling the database.
START-->RUN then enter

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.exe x:\myapp.mdb" /decompile

Change the path/name of the mdb to your specific mdb. Also the path to MSACCESS.exe may be different on your PC.

 

[TheAceMan1]

Howdy DougP . . .

I've suffered the same thing through a number of Db's . . . I believe 4. The fix parallels [blue]PHV's[/blue] post, with a few extra steps. From top to bottom they are:
[ol][li]Cut the line out to the clipboard.[/li]
[li]Perform a compile (don't go any further until the compile is clean!).[/li]
[li]Compact & repair[/li]
[li]Close then open the Db.[/li]
[li]Reinstantiate/paste the save line in its proper place.[/li]
[li]Perform a compile (don't go any further until the compile is clean!).[/li]
[li]Do your testing . . .[/li][/ol]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[jmgaddis]

I've had this happen many times, except it was using Breakpoints... very annoying.

I believe what has worked for me is to go to the line below your code where it stops and completely retype the line (retype, not copy and paste the original line), then delete the line where it stops (or comment it out).

Hope this helps.

Thanks,
John