Calling Access from Access stops code in debug mode 
Author Message
 Calling Access from Access stops code in debug mode

Hi,

I wrote some code to call a function in an Access database by
Application.Run. It worked perfect. Now I put the same code into another
Access database and try to do the same.

When I come to "Application.Run", a second window pops up (with the
second database) and code execution stops. The only way to continue is,
open the code module and hit F5 to resume execution.

It seems this is a de{*filter*} problem. Somehow the two Access instances
must communitcate and decide that I probably want to debug right now.

Did anybody have the same problem and knows a workaround?

Thanks, Christoph



Wed, 03 Mar 2004 01:09:35 GMT  
 Calling Access from Access stops code in debug mode
Does the code halt at a location where you previously had a breakpoint set?
I've only been working with Access 2000 for a few months, but I've already
seen phantom breakpoints in local code:  code halting at places where I had
previously set and then removed breakpoints.  I was able to get rid of them
by Debug->Clear All Breakpoints, followed by Debug->Compile.  If I recall
correctly, it didn't always work the first time, but so far it has
eventually worked, so you might try that with your second database.

--
Dirk Goldgar
www.datagnostics.com

(to reply via e-mail, remove NOSPAM from address)


Quote:
> Hi,

> I wrote some code to call a function in an Access database by
> Application.Run. It worked perfect. Now I put the same code into another
> Access database and try to do the same.

> When I come to "Application.Run", a second window pops up (with the
> second database) and code execution stops. The only way to continue is,
> open the code module and hit F5 to resume execution.

> It seems this is a de{*filter*} problem. Somehow the two Access instances
> must communitcate and decide that I probably want to debug right now.

> Did anybody have the same problem and knows a workaround?

> Thanks, Christoph



Fri, 05 Mar 2004 06:47:11 GMT  
 Calling Access from Access stops code in debug mode
Hi Dirk,

Dirk Goldgar schrieb:

Quote:
> I was able to get rid of them
> by Debug->Clear All Breakpoints, followed by Debug->Compile.  If I recall
> correctly, it didn't always work the first time, but so far it has
> eventually worked, so you might try that with your second database.

It worked perfectly, thanks. You saved my project, that should run
tomorrow :-)

Christoph



Fri, 05 Mar 2004 00:27:59 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Stopping visual basic coming out of DEBUG mode (NOT 0 lines)

2. Implements interfaces not called in debug mode

3. Calling Excel code within Access code?

4. Can't enter module code in debug mode

5. Cannot Debug VB code in Access mdb

6. Code only works in debug mode?

7. Code only works in debug mode?

8. calling access querydef that calls a user defined access function

9. Conditional Compiling Code in Debug Mode

10. a way to stop code executing in Access?

11. Debug mode vs. Run mode

12. Stopping database access from Access

 

 
Powered by phpBB® Forum Software