Starnge Access behavior

[Lp12]

Hi All,
I put a breakpoint to debug a procedure and when i finished i cleaned it up.
from Access form, when i enter the Sub (by clicking a button) instead of
getting the procedure to run the code, the VBA editor appears and stops in
the exact place where once was my breakpoint. I've tried to compact the DB
but nothing changed.
Any suggestions? How to get rid of that strange behavior?
Thanks in advance.

 

[Allen Browne]

This indicates a corruption that is usually fixed easily by turning off Name
AutoCorrect and decompiling.

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access, and compact again.

Post a reply if you are still stuck at this point.

 

[BAC]

I usually find that this occurs when I close the dtabase before clearing up
the breakpoint and the breakpoint will re-occur until I use the Ctrl+Shift +
F9 key combo to "Clear All breakpoints" then close the database.

When I re-open the db the the breakpoint is usually gone. Is this not
sufficient or is decompiling/compacting etc really necessary (not knocking
the benefits of compact/repair, just wondering if needed for this problem).


BAC

 

[Allen Browne]

If "Clear All Breakpoints" works for you, that's great.

I have not observed that solving the problem, but the decompile does IME.