Microsoft Access Debugger Freezing

[geoffrobinson]

Hi,

When I try to debug VBA code in Microsoft Access 2003, I keep running
into an issue. I'm trying to debug some code found in a module which
is accessed by a form. When I try to stop the debugger (and the form
from running), the whole application hangs. It doesn't do anything and
I have to kill it with Task Manager.

When the code reaches the line with a problem and it executes an error
message does up as expected. After I click "debug" or "end", the
application hangs in that situation as well.

So it seems the basic problem is that Access can't gracefully exit the
debugger.

Does anyone have any idea on how to resolve this?

thanks for any help in advance,
Geoff

 

[Klatuu]

Describe hang.

I have never had a problem like that. Clicking the End button should stop
the code from running and the highlight should disappear.

 

[Robert Morley]

Two things come to mind:

First, try decompiling your Access database. Simply launch Access.exe with
the full path to your database (in quotes, if necessary) and the /decompile
switch.

Second, and far less common, are you using any API calls...particularly ones
that use Callbacks? These can often cause problems with debugging.


Rob