Access/SQL/Scheduled task Issue

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.

Thanks,

JenG

Answer 1

Hi, JenG123

You have mentioned that “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”. Here I need to confirm with you that have you check the log. Is it displays some errors? With the errors we can find the cause of this issue. Please share it with us.

Regards

Deepak

Answer 2

Hummm, seems like it should work just fine.  Are you doing it like this?

http://www.sevenforums.com/tutorials/11949-elevated-program-shortcut-without-uac-prompt-create.html

Remember, scheduled Tasks cannot run with a blank password, or an incorrect password.  Make sure your password is correct!

---

Knowledge is the only thing that I can give you, and still retain, and we are both better off for it.