This may be related to question Q_28392369.
We have a Windows XP scheduled task that runs nightly; it kicks off a bat file that in turn calls other bat files. One of the bat files is shown in the attached image batb.jpg.
As can be seen, batb kicks off an Access Macro; that macro is shown in Macro.jpg. I can capture any of the steps in the macro & provide them if necessary.
Until recently, the other version of this Macro had run for years every night; I had to make a new version because of other issues
Now it does not correctly run overnight.
If I run batb from the command line, it works. However, it does ask me if I want to update a table; I think it asks several variations. The first few steps in the Macro relate to updating a table; the rest extract data from the database into csv files.
I'm guessing, based on the referenced question, that I should turn off action messages in the Macro AND the queries. Is that correct?
How do I do that? Note, this is Access version 2003.