VBA Breakpoints do not work

[Ella Liskov]

In my VBA code, breakpoints, as well as other debugging tools, do not work. I
can create breakpoints, but they are just ignored. It does not matter where
they are. On the other hand, using the same Access 2002 software, breakpoints
work fine in sample Northwind database. Any ideas?

 

[Allen Browne]

If your breakpoints are not being respected, the database is partially
corrupt.

Compact it: Tools | Database Utilities | Compact.

Then 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"

That should solve the problem.
If not, you can quickly rebuild your database with the 6 steps for the first
symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html