Invoke/Modify Access Macros Programmatically

[swstran]

Hello,
Is it possible to invoke/modify an Access Macro programmatically?
Please help! Thanks.

 

[Psychpt]

whatever you want to do in a macro you can do programmatically, so why modify the macro? just run the code.

 

[swstran]

Hello,
Yes, I can just run the code directly. However, performance is a big issue for me. I'm doing lots of table comparasions using about 30+ queries. It would be a lot easier if Access allow to create stored procedure. By storing all queries in a macro, it costs me only one call and clearly cut down the run time dramatically. The reason that I have to modify a macro is for the purpose of migration, from version to version.
Thanks.