Append query autorun problem

[Guest]

I have a scheduled task that runs at night that opens up a database and runs
several append queries that are stored in a macro.

All of these are working fine except on query that is faily large and takes
a little while to run....it never appends overnight. Every morning I have to
re-run the query myself. I have put the openQuery function for this
particular query in different spots in the macro (first, last, in the
middle), with no effect. All of the other queries run fine over night except
one.

I'm not sure if this is a system issue (with the computer I'm using) or if
there is something in Access I could do to make sure it runs? Any help would
be greatly appreciated. Thanks!

- Nick

 

[Guest]

Try putting that particular query in its own macro and running it at a time
when the other queries are already complete.