DarrenWard
IS-IT--Management
I have a parameter table that contains various pieces of information, one being wether the system is availible or not, becuase i have users spread out over various buildings its a pain getting people out for period end proceedured or system maintenance.
My idea is to have a timer that fires and checks every couple of minutes to see if the system is availible or not, if its not it will close all tables and exit the user back to the main menu where they will not be able to make any menu selections until the system is free again.
The thing that im worried about is what happens if the timer fires in the middle of an update routine, or will the timer event wait for the code to finish before it is executed, im worried about data corruption as a result of introducing this feature, has anyone else done this before or have any suggestions?
Darren
GuiltyMaggot - The best rock band in the world!
My idea is to have a timer that fires and checks every couple of minutes to see if the system is availible or not, if its not it will close all tables and exit the user back to the main menu where they will not be able to make any menu selections until the system is free again.
The thing that im worried about is what happens if the timer fires in the middle of an update routine, or will the timer event wait for the code to finish before it is executed, im worried about data corruption as a result of introducing this feature, has anyone else done this before or have any suggestions?
Darren
GuiltyMaggot - The best rock band in the world!