Hi,
I have written a batch file to run a macro in MS Access. The macro has several automated keystrokes such as =Date() etc.
I have scheduled the Windows Task Scheduler to run the Batch file which in turn runs the Macro every 3 hours. When computer is unlocked everything works fine. However, when I lock the computer the task scheduler starts to run the batch file and the macro. However, when the macro is expected to get the automatic keystroke for current date, computer does not provide the keystroke and macro fails. Does anybody know how I can fix the problem so that the macro will run even though the computer is locked.
I have written a batch file to run a macro in MS Access. The macro has several automated keystrokes such as =Date() etc.
I have scheduled the Windows Task Scheduler to run the Batch file which in turn runs the Macro every 3 hours. When computer is unlocked everything works fine. However, when I lock the computer the task scheduler starts to run the batch file and the macro. However, when the macro is expected to get the automatic keystroke for current date, computer does not provide the keystroke and macro fails. Does anybody know how I can fix the problem so that the macro will run even though the computer is locked.
