Charlie, The task may run at a time when no one is logged in on the computer. Mapped drives are assigned at login, and are unlikely to exist to a scheduled task that runs in the middle of the night. So be sure that you use UNC names, not mapped drives, in both the batch file and the R:BASE code.
Also be sure that the scheduled task has "login" or "security" settings that allow it to update the folder with the R:BASE database. And be sure it's not running at a time when the database files might be locked by a maintenance process. Bill On 1/4/08, Charles Parks <[EMAIL PROTECTED]> wrote: > > I have a scheduled task that runs once a day that is supposed to load > stats based on another table into it. > > If I double click on it from the scheduled task it runs and inserts values > into the table. > > If I just let it run from the scheduled task it updates the last ran date > but it doesn't insert values into the table. > > What should I be looking for causing the different behaviors? >
