Problem with a VB6 app using an ACCESS DB, which references a Foxpro table via a link.
The app includes a Report module that uses a CR8.5 report. On the first entry in the Report module it works as expected. I can successfully leave and reenter the module with no problem. The problem... If I terminate the VB app, again invoke the VB app, then invoke the Report module, the VB app task hangs and has to be terminated. The VB app always works until I get to the Report module. If I restart the computer the cycle starts again -- the Report module works the first time only.
This even occurs in debug mode. However, if I set a breakpoint in debug mode and step through the Report module it works fine. If I remove the breakpoints and invoke the Report module it hangs again.
I suspect that a resource is left open when the VB app terminates but I cannot identify the source.
Please, can someone shed light on this problem?