Hi,
I have an Access Macro (works in 2003 & 2007) which connects to external servers to download data and execute queries. It takes approximately 25 minutes for running all the pass-through queries and internal queries. When the connection is slow, I get an ODBC call failed error. I increased the time-out from 60 seconds to 180 seconds. Now the macro works fine most of the time, but fails few times.
As the number of queries are more, it is difficult to run all the queries manually. Is it possible to have the macro display a "Retry" option if the particular pass-through query fails? Currently it displays a "Stop All Macros" button when the macro fails. After this error,I am running the macro from the first again, as it is difficult to run individual queries.
Is there a solution, either in Access macro or in VBA?
Thanks a lot!
I have an Access Macro (works in 2003 & 2007) which connects to external servers to download data and execute queries. It takes approximately 25 minutes for running all the pass-through queries and internal queries. When the connection is slow, I get an ODBC call failed error. I increased the time-out from 60 seconds to 180 seconds. Now the macro works fine most of the time, but fails few times.
As the number of queries are more, it is difficult to run all the queries manually. Is it possible to have the macro display a "Retry" option if the particular pass-through query fails? Currently it displays a "Stop All Macros" button when the macro fails. After this error,I am running the macro from the first again, as it is difficult to run individual queries.
Is there a solution, either in Access macro or in VBA?
Thanks a lot!
