Link to home
Start Free TrialLog in
Avatar of Richard Korts
Richard KortsFlag for United States of America

asked on

Access Run in "Batch"

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.

Thanks!
batb.jpg
macro.jpg
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial