Command to call Access Macro

[tstreeter]

Is there a way through the SQL portion of the appliaction to connect to a Access DB and then reference the macro that resides within and execute?

I'm currently managing several DB to populate data for a Web Dashboard that's Flash Based.

Within each DB I have a macro that runs several Make Table Query', Update,Delete Querys, Append Querys, etc, etc.

I'm currently have AA macros created through Web Recorder that Open the DB via a shortcut placed on the taskbar and then they navigate to the Access Macro and execute.

However, this method is becoming cumbersomeas currently there are aprox 10 tasks that run through the night. If one querys run longer than the other. The remaining tasks will tend to run on top of each other which in turns causes confusion in the playback

I believe if I can get the SQL portion to work I will be able to eliminate all of the mouse movement issues and just have it operate as a command/exe.

Thanks

[forumsupport]

Hello,

Using Database command, you can connect to your database and issue SQL queries or INSERT/UPDATE/DELETE statements. You can also run any procedure created and stored in your database. Unfortunately, it does not provide an option to call a macro. However, you can use 'Insert Keystrokes' command to run Access macro. Keystrokes are more reliable as they will work irrespective of change in screen resolution.

You can chain your 10 tasks together using 'Run Task' command. In that way the next task will run only when the first ends. Create one task and within this task run other tasks one after another and schedule just this task. That way you do not need to schedule different tasks.

We have attached sample tasks for your reference. Please copy .atmn files under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. Copy sample.mdb under C:\.
The Main Task will run Macro1 and then it will call Sub Task that will run Macro2 and Macro3 of sample.mdb.

Hope that helps.