Debugging Breakpoints Not Working

[JR_06062005]

I'm trying to debug some code and am using the breakpoint feature of the
debugging mechanism. Problem is my code continues to run ignoring the
breakpoints. I checked everything I know to check, but can't figure out why
this is happening.

I would appreciate any anyone can offer.

 

[Allen Browne]

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"

 

[JR_06062005]

I tried hold the shift down and opening the application. This seems to have
worked. Do you think I still need to decompile the database? That is, do
you think I might need to do this for other problems that may come up?

Thanks for your help.

 

[Allen Browne]

If the issue was caused by permissions or special keys disallowed, a
decompile is not needed.

 

[Ofer]

If you put breakpoint in the mdb, to debug, and then close the application,
when you open it again, the break point been removed.

So when you open the mdb with the shift key, and then put the break point
and run the application without closing it, it will work.
To add a break point that will work even when you close the application, in
the code you can write , Stop , that will stop the code, the problem with
this technique is that programmers forget to remove the stop, and then the
users has a problem, while the code stops

 

[oozyscab via AccessMonster.com]

Sounds like you have the 'Use Special Access Keys' in the Startup options
disabled. I have run into this same thing before and thought that I was
going insane. You need to go to the 'Tools' - 'Startup' menu and check the
'Use Special Access Keys' box and then your code will break when you want it
to.

Cheers,
Eric