MS Access: The RunMacro action was canceled.

I was trying to run an msaccess macro using Windows XP scheduled tasks. It wasn’t working. It gave me the following error when it tried to close access after the macro was finished:

The RunMacro action was canceled. You used a method of the DoCMD object to carry out an action in Visual Basic, but then clicked Cancel in a dialog box. For example, you used the Close method to close a changed form, then clicked Cancel in the dialog box that asks if you want to save the changes you made to the form.”

My server was running macro’s fine, so I looked at the Task Properties and noticed they were different.

The solution: Continue reading…