I have an MS Access app that is supposed to run at 3am. I've setup a Windows Scheduled Task for 2:50am, which runs a batch file, which runs the VB Script file, which runs the Access App.
The app loads and executes fine. The problem is that the app is supposed to copy a csv file that was created into a folder that only has certain permissions. I have permission to copy to this folder. But I'm not the one logged in and running the app when it runs at 3am. The task runs on its own. So the copying of the csv file fails.
Does anyone have any idea on how I can start a Windows Scheduled Task with my user credentials?
Hope this is clear. Let me know if you need more info. Thanks.