Breakpoints No Longer Working

[Ray Moon]

All,

I have developed an MS Access application. I recently discovered an error in
the code for a data entry form. I created a button that will do some
calculations when clicked upon. I set breakpoints in the code so that I
could see what was happening. The problem is that execution does not halt at
the breakpoint. In fact, execution does not break at all. I know that the
code is being executed because I have changed the code and the information
displayed changes.

I do not remember changing anything to disable breakpoints, nor did a search
of the Microsoft Knowledge Base reveal anything about this problem.

Does anyone know what is happening and how to get the breakpoints working
again.

Thanks in advance.

Ray

 

[Allen Browne]

This can occur with a type of corruption that you can fix with a decompile.

Decompile a copy of 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"

Then compact the database, compile, and test again.

BTW, IME the most common cause of this kind of corruption is editing the VBA
code while the form is running (typically in Break mode) instead of
switching the form to design view. Other ideas to prevent corruption:
http://allenbrowne.com/ser-25.html