RUntime crashing

[QB]

I developed a db which get deploy using runtime. It works great on a full
version of Access without any errors. However, when I deploy it certain
function (launching 2 reports in particular) crash the database. A runtime
error has occured and the db must close.....

Is there a way to return the line number that caused the fatal error so I
can troubleshoot because going line by line would be horribly long because of
out of my control reasons.

Thank you,

QB

 

[QB]

The exact error is

'Execution of this application has stopped due to a run-time error.
The application can't continue and will shut down.'

What I love even more is that it is bypassing my procedure's error handling
routine completly so I can't even get any indication of the actual source of
the problem. I Tried runing the app in run-time mode on my PC and it still
has no issue. It is only once deployed on the network with run-time that it
crashes.

QB

 

[QB]

Further examination has shown that the problem is spread to multiple reports
in this db. Some still work but most now cause the db to crash?! Many of
the reports worked in my previous version and were not modified in any way,
not even opened, so why would they now not work?

QB

 

[Tony Toews [MVP]]

Is there a way to return the line number that caused the fatal error so I
can troubleshoot because going line by line would be horribly long because of
out of my control reasons.

Yes. Install MZ Tools which is a free download. When you're in the
code two button clicks will insert error handling code and line
numbers on each statement. You will have to update the standard
error handling code to include Erl which is the error line number.

Tony