Launch Function from Command

[Secret Squirrel]

Is there a way to run a function from the windows command? I need to schedule
a function to run nightly so I wanted to set this up through the windows
command prompt. My DB has ULS so I need to also enter a username and password.

 

[Tom van Stiphout]

On Fri, 12 Dec 2008 19:15:01 -0800, Secret Squirrel

type:
at /?
at the command prompt.
Personally I use the Scheduled Tasks interface at Control panel >
Scheduled tasks.

None of this has anything to do with Microsoft Access, the topic of
this newsgroup.

-Tom.
Microsoft Access MVP

 

[Secret Squirrel]

Actually it does. I'm trying to launch my MS Access database from the command
prompt and run a function.

 

[Tom van Stiphout]

On Fri, 12 Dec 2008 19:46:01 -0800, Secret Squirrel

Sorry about that. You are right. I was a bit too quick to dismiss your
post.
The MsAccess command line is documented in the help file. You can
certainly run an app with ULS and the /wrkgrp command line switch. You
can also use the /x option to run a macro of your choice (in addition
to the AutoExec macro).

-Tom.
Microsoft Access MVP

 

[Secret Squirrel]

Can I also run this command via the windows scheduler or would I need to
create a vbs to do this? (this question may not be for this group)

 

[Tom van Stiphout]

On Fri, 12 Dec 2008 20:22:01 -0800, Secret Squirrel

Yes, you can. The windows scheduler asks for a command line. Enter a
command line along the lines of what is documented in the help file.

-Tom.
Microsoft Access MVP