General discussion


Help - batch file /auto-logon not sure where to go

By Jessica Lynn ·

I was asked to find a way to have an access macro run after hours, with no user intervention. Not a big deal. MS has an article on using the task scheduler to run an Access macro.

However, it's the after hours part thats driving me crazy. For an access macro to run using the task scheduler, the comptuer needs to be logged in (so access can be opened).

My thought process was, let's find some program/batch cmd etc that will log on the computer at a preset time (ex 10 pm). Then use the task scheduler to run the access macro.

I would then be able to use a program like DevCon to restart the computer.

I've searched all day and can't find something to auto logon to windows 2000.

Any ideas?


This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

There may be a better way.

by Spanky In reply to Help - batch file /auto-l ...

The first thing that comes to mind is leaving the user logged on and locking the workstation. That would be the easiest solution.

Otherwise, you could enable Wake On Lan on the NIC, configure the machine for auto admin logon and boot it remotely from another machine that runs a batch file at a specific time that will contact the machine to wake it up. Then when it's booted it can run it's scheduled task.

It's a very complicated solution to what seems like it should be a more simple problem.

Last thing, did you try setting the scheduled task using the command line and allowing it to interact with the desktop? The syntax would be something like this:
"AT 22:00 /interactive myprog.exe"

That should allow it to run under the system context, which has full permissions on the local machine, but won't have permission across the network. If it has to run across the network to access another machine, you'll have to make sure you give the required permissions to "Autenticate Users" on the remote machine.

Long and rambling but I hope it covers all of the bases.


Back to IT Employment Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums