windows scheduler and access macros

[1-acxi-1]

Hello,

Can someone help me to look into using Windows Task Scheduler to set up
a command line to open my database and run a few macros on certain
predetermined dates? I was able to set up a task to open the database
but this was directly connecting to the base not running a command
line. Any help would be greatly appreciated!

Thanks.

 

[Steve Schapel]

1-acxi-1,

The basic syntax of the command line should be like this...
"C:\Program Files\...PathToAccess\Msaccess.exe" "C:\PathToDb\MyDb.mdb"
/x NameOfMacro

 

[freakazeud]

Hi,
check this article:
http://support.microsoft.com/?kbid=230575
The macro you are calling with the command line would be the macro calling
all other macros or modules...make sure the last line is to shutdown access.
HTH
Good luck

 

[1-acxi-1]

Man this worked perfectly! Do you have the syntax to close access (and
the batch file) or do i need to call another macro for that?

Thanks you so much!