Schedule macro

[Guest]

I've scheduled a macro with the Schedule Tasker from Windows and I'm having a
problem getting the cursor to show up in the password box so that I can type
a password. It works fine if I leave my computer on without locking my
computer. Once I lock the computer, the schedule gets to the screen where a
password must be entered and it waits until the mose button is pressed before
you see a cursor in the box. I don't know how to automaticall y execute a
mouse down at this point.

Any suggestions?

Thank you,

Sarah

 

[John W. Vinson]

I've scheduled a macro with the Schedule Tasker from Windows and I'm having a
problem getting the cursor to show up in the password box so that I can type
a password. It works fine if I leave my computer on without locking my
computer. Once I lock the computer, the schedule gets to the screen where a
password must be entered and it waits until the mose button is pressed before
you see a cursor in the box. I don't know how to automaticall y execute a
mouse down at this point.

Any suggestions?

Thank you,

Sarah

It is probably a lot simpler to bypass the prompt altogether; instead pass the
ID and password as command line parameters:

"C:\Program Files\Microsoft Office\Office12\msaccess.exe"
"K:\SomePath\mydata.mdb" /wrkgrp "K:\Somepath\mydata.mdw" /user SomeUser
/pwd DontTellAnyone /x Macroname

It's a good idea to have a user named SomeUser with VERY limited privileges -
e.g. only enough privileges to run the scheduled macro.

John W. Vinson [MVP]