VBA to run two module or sub simultaneously.

[johnseito]

Hello,



Is there a way to have VBA through window or whatever way to run two or more module or subs at the same time ?

I have a big program with a lot of data and loops but they are in different module or sub. I need it to complete quickly and the way I see it is running 2 or more module or subs simultaneously.

Please advise.

[June7]

Certainly not in same db. Access does not have 'multi-thread' processing - at least that's the term I've read. Although maybe form Timer event comes close. Never tried to initiate procedures from two open db. Try it - what happens?

[CJ_London]

As June says, Access does not have multi threading. To improve performance have you confirmed that the functions you are running are as efficient as they can be - and if referencing tables that these are properly indexed? Perhaps more can be done with queries rather than using code and recordsets for example.

[johnseito]

How about this, use VBA to run a Macro that runs a dot.net app that runs two procedure.
But have the dot.net app be able to pass variable from the first procedure to the second procedure.
Running both procedure simultaneously.

[CJ_London]

no idea whether that is doable or not - try it and see