I have a DTS package set up to execute two queries in an
Access mdb. When I manually run the steps I get the
records I need and can proceed with other tasks. However
I've scheduled the package to run once a day and have
found that it has stopped importing the results of the
queries. I have checked my connection properties and they
seem to be correct, as I can still generate the results
manually. It only happens when I schedule the package. Any
ideas that may solve this?

Thanks

M

Gotcha. That makes sense. Thanks!

M


server environment. So, for example, if the path to your
access db is E:\mydir\myfile, then that's E: on your
computer; E: may not be defined on the server.