DoCmd command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I notice I could execute a macro, that contain update queries or alter table
or select into... in Access 2002. I was trying to locate the limitations of
macro in the online help, but couldn't find it. If you could please share w/
me where I can find more info on macro limitations. Thank you.

Ben


--
 
Ben,

What type of limitations are you thinking of? You can use an OpenQuery
action in a macro to run an action query such as you described. There
is a limit of 999 actions in a macro, so, assuming you want to also use
a SetWarnings/No action in the macro to suppress the action query
confirmation messages, I guess that means a limit of 998 action
queries... but I don't think this is what you are referring to.
 
Back
Top