Application always quit in access runtime on every run-time error

[Ramnik]

Hi everyone,
I have setup a small application with front/back end in local network. On client machines i have installed access runtime. Although it works fine but it suddenly quit when there is any run time error while working on client machine. Although on server machine ( where full version is running it didn't close the application ).

What i need is an option to not quit the application completely.
As i am not expert in coding of try/catch statements I need a simple solution for time being .

Thanks.

 

[pbaldy]

You can add error handling:

http://www.baldyweb.com/ErrorTrap.htm

 

[vanceric]

Hi everyone,
I have setup a small application with front/back end in local network. On client machines i have installed access runtime. Although it works fine but it suddenly quit when there is any run time error while working on client machine. Although on server machine ( where full version is running it didn't close the application ).

What i need is an option to not quit the application completely.
As i am not expert in coding of try/catch statements I need a simple solution for time being .

Thanks.

It may not be the best solution but you can skip error trapping and just add

On Error Resume Next

It will skip the line of code where the error happened but it needs to be added to every function where you could encounter an error. There's not global solution I'm aware of in Access.

 

[spikepl]

Download MZ-tools. It makes adding error handlers extremely easy

Removing error handling by On Error Resume Next is a toxic band-aid solution, and not recommended.

 

[Galaxiom]

It may not be the best solution but you can skip error trapping and just add

On Error Resume Next

Not only "not the best solution" but I would say not really a solution at all.

 

[Ramnik]

Thanks Guys, I will give it a try and will tell if i have any doubts.