I am trying to build a macro in Access 2007 and one of the steps I'd like to add is the RunSQL step. It is not available in the list of Actions. I've read this might be related to Trust Center settings. I verified the location of this db is in a trusted directory, which happens to be my desktop.
Does that have anything to do with it or am I looking at the wrong issue?