-
I have a system which is connected to a LAN. It regularly (every 10 mins) updates a couple of variables which store share prices, from off two internet sites.
Unfortunately when the network is particularly busy and the system tries to update the share prices, it can cause the system to hang and then it has to be rebooted.
Is there any way to check how busy the network is, and if there is a lot of traffic on it then to ignore the request to update the share prices and therefore avoid the risk of locking up the entire system.
I have error trapping in place in the relevant functions.
Any help appreciated.
-
You could probably throw some DoEvents in your procedures as long as the user does not have the ability to cause a procedure to be called recursively (such as a click event).
That will allow the operating system to continue processing ...
-
Unfortunately the user has the ability to constantly press buttons and change the information they are looking at!
It's an information kiosk.
I will look into disabling the buttons whilst using DoEvents though, to see if I can get around the prob this way.
Thanks for the swift reply :)
