Use task scheduler to start up an MDB form?

[fred]

hi,

i'm not sure which newsgroup to use, so feel free to point me elsewhere.
(I've tried one other newsgroup.)

i have an MDB that produces many reports, automatically (via the startup
form's on open script). works great.

now, i want to automate this, so that it happens once every evening. i
created a macro that can be called via an Access startup command, and
double clicking on a .bat file that uses this, it works great too.

so, now i've tried both XP's task scheduler, and also sql server agent.
but neither seems to work. they start up Access (i see an MSACCESS.EXE
task in the Processes tab), but the task does not seem to do anything. i
have to kill the Access task.

anyone have any hints on how to do automatically trigger Access to start up?

thanks!

fred