Schedule a Task in Access

[Guest]

Hello everyone, I did not know where to post this, so I apologize if it is in
the wrong form.

I am trying to schedule a task in Access 97/Win XP to be able to send a
email in Lotus Notes. I have the code for the Lotus Notes, but I am having a
hard time getting the Windows Scheduler to run a macro. I tried using the
path to my MDB plus x/ "macSendMail", but all it does is opens the database
and never fires the macro. Can anyone tell me what I am doing wrong?

 

[Douglas J Steele]

You need to include the path to msaccess.exe, not just the mdb and /x
switch.

The switch is actually for the executable, not the database. Unless you've
modified the default file association, switches get ignored when all you
have is the file in the shortcut.

Don't forget to put quotes around the full path to msaccess.exe, since it's
almost certainly going to have spaces in it (C:\Program Files\....)