K
Kevin B.
I have created a simple Macro in Access that opens a report and prints it
then closes the report and exits access and it works perfectly when I run it.
I want this to run unattended so i create a batch job that simply runs the
macro and when I execute the batch job it works.
This is the command in the .bat file.
"e:\program files\officexp\office10\msaccess.exe" "path\databasename.mdb"
/nostartup /x macroname
The problem I am having is if I create a scheduled task in windows to run
the batch file, It hangs as though its waiting for something. I am unable to
see what its doing because its running in the background like I want it too.
Does anyone know how to run an Access Macro unattended as a scheduled task.
Thanks,
then closes the report and exits access and it works perfectly when I run it.
I want this to run unattended so i create a batch job that simply runs the
macro and when I execute the batch job it works.
This is the command in the .bat file.
"e:\program files\officexp\office10\msaccess.exe" "path\databasename.mdb"
/nostartup /x macroname
The problem I am having is if I create a scheduled task in windows to run
the batch file, It hangs as though its waiting for something. I am unable to
see what its doing because its running in the background like I want it too.
Does anyone know how to run an Access Macro unattended as a scheduled task.
Thanks,