Access/SQL/Scheduled task Issue RRS feed

  • Question

  • Hi - I am not sure which forum to post this on so I am starting here.  I will try to keep it brief but a little background is necessary:

    I have a scheduled task that runs to call a batch file (the batch file gets files from a server and opens an mdb file.  In that .mdb file, data is imported, then Access queries run on that data and then SQL server is opened through Access DB and data is loaded to SQL).

    Recently, I noticed that the program was running but that the SQL load was not happening.  So, all other tasks are performed properly except the SQL load.

    Now, I have found that if I call the .mdb file directly from the scheduled task, instead of calling the batch file, then the whole operation runs through and SQL does get loaded.

    So, it seems that the problem is that if I call a batch file from the scheduled task then it will not load SQL but if I call an mdb file from the scheduled task, it will load SQL.

    Please advise if you need more information and please advise if I should include this on a different forum.



    Thursday, February 25, 2016 8:52 PM

All replies