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
Richard KortsAsked:
Who is Participating?
 
als315Connect With a Mentor Commented:
You can remove warnings with SetWarnings No in the beginning of your macro:
http://office.microsoft.com/en-us/access-help/setwarnings-macro-action-HA001226301.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.