I have an app which is written in VB 4.0 which munches a lot of data from text files then data is manipulated and dumped to Oracle and Access (yes 2 databases). Problem is, this app is run on a rather old machine and resources on that machines is rather limited. The app would “freeze” the machine to point that I need to reboot the machine by turning it on and off. When this happens I have to restore 2 databases with backup data cos the app kind of stops in the middle of data manipulation. I have to find a way to solve this problem.
Okay I know giving that machine more resources would solve it but this has been ruled out. I was asked to write a script/procedure that would recover the app to the previous stage. i.e. If the app crashed, whenI restart the app, it would ask me “Would you like to continue processing last batch of data?”. Could anyone please help ?
