Hi. I have several apps written in A2K that extracts information via ODBC which are triggered at specific time intervals (via Scheduled Tasks). Problem is that if the extract fails due to an ODBC error, I tried to trigger the timer event of the form for it to wait and run again say in 5 minutes but it won't work. Then I tried creating another form that calls the extract form within the database, but it seems that A2K remembers the first ODBC error. Then I tried to refresh the links, but got the same result.
The only other thing that I can think of is to create say a A2K Launcher app that will call the other extracts (access databases). The Launcher app will have a table where the other extracts are linked to and will continuously monitor the table for any errors. If an error occurs, after say a few minutes, it'll call the specific extract that errored out. (Hopefully this will work)
Any ideas are greatly appreciated. Thanks in advance!
Jason
The only other thing that I can think of is to create say a A2K Launcher app that will call the other extracts (access databases). The Launcher app will have a table where the other extracts are linked to and will continuously monitor the table for any errors. If an error occurs, after say a few minutes, it'll call the specific extract that errored out. (Hopefully this will work)
Any ideas are greatly appreciated. Thanks in advance!
Jason
