starting up Access automatically?

[Fred]

hi,

i'm not sure which newsgroup to use, so feel free to point me elsewhere.

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.

so, now i've tried both XP's task scheduler, and also sql server agent. but
neither seems to work. i see an MSACCESS.EXE task, but it does not seem to
do anything. i have to kill the task.

anyone have any hints on how to do this?

thanks!

fred