RunCommand question

[Lisa]

This is probably really basic, but in my macro is it necessary to have
OpenQuery before I tell it to RunCommand/Run ? I'm trying to set a macro to
run my make-table query, but if I can avoid having to open the query itself
first I can save about 15 minutes. Am I even using the correct set of
actions? Help!

 

[Eric Blitzer]

the OpenQuery action in a macro is running or designing.
Make sure the view is set to Datasheet.

 

[Steve Schapel]

Lisa,

If it's a Make-Table Query, you can't "open" it. Using an OpenQuery
macro action for an Action Query such as Make-Table will cause it to Run.

As for the comment about 15 minutes, well, that's a mighty big query! I
would guess there might be ways to make it more efficient.