Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report.export - access denied - need to continue

Status
Not open for further replies.

Transcend

Programmer
Sep 29, 2002
858
AU
Hi all

I have a vb6 exe that runs in the background as a service. It is supposed to run scheduled reports. However when it tries to export a report to a location it doesn't have access to it just crashes with 'access denied'. It doesn't enter the error handler or anything. If this occurs i want the service to continue not crash completely.

How can i trap for this error so it goes on to the next report?

I have error handling around the code but it doesn't even get there?

Transcend
 
When you say you have error handling, what does it look like? Do you have an on error goto or resume next in the module?

"I think we're all Bozos on this bus!" - Firesign Theatre [jester]
 
Ahh dear i figured out what i was doing wrong - had break on all errors checked.

My apologies.

Transcend
[gorgeous]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top