Auto Trigger MS ACCESS Code

[tuktuk]

hey there,

I've recently switched to window 7.

previous on XP i used task scheduler to open a MS Access database at a particular time daily where there was code attached to a form (which was opened when database opens) that runs code if opened at the correct time (when the scheduler opened the database/form) and then provided a msg box otherwise.

i'm running into issues w the windows 7 task scheduler. doesnt seem to work as well.

are there other suggestion on how to trigger ms access code on a repetative sched?

thanks
tuk

 

[tuktuk]

hey there.....so i figure it out.

on the task scheduler general tab i originally had the RUN WHETHER USER IS LOGGIN IN OR NOT.

once i changed it to RUN ONLY WHEN USER IS LOGGIN IN >>>>>success!

not really sure why but it would not run w the first selection. thanks for the help.

 

[xenou]

Good to know. I haven't used the other setting though I meant to test it too. I lock my computer at the end of the day but stay logged in overnight.
ξ