Hi All,
I have many workflows using APIs that simply open an Access database that auto exports one or more reports.
Sample: ---.OpenCurrentDataBase("Database name including its path")
All these reports have been working for months, but even tough the workflows have continue to run at scheduled time with no error, reports are not been generated for 3 days (They work well when database is opened manually -> All it does is auto execute a macro, generate the report and exit).
While troubleshooting, I noticed that before script execution would not continue the flow (pause) until reports were generated. Now, MS Access opens and closes even before the AutoExec macro in the databases gets to run.
Why this sudden change?
By the way, when I run it directly from the Script editor it works as expected.
Ideas will be welcome,
Porfirio