Macro Or VBA

[jo15765]

I have a database that is all based off queries/macros. For example, on a button press event a macro will fire, that runs 4 queries. Running these 4 queries usually takes around 15 minutes. Would this process be any faster if I altered the macro and set everything to run through VBA? Or would the speed be to comparable to even begin making the change? Thoughts?

[John_G]

If all the macro does is to run those 4 queries, I doubt there is anything to be gained by converting the macro to VBA. It is the queries themselves that are taking the time, not the macro, and changing to VBA wouldn't change that.

[jo15765]

@John_G - thank you for the response. I did not think so, but was unsure so thought I would ask before I began spending time to convert aimlessly.

[aytee111]

Most everyone on this forum will tell you VBA, we are not fans of macros. Speed differential - not really. The speed of queries depends on a lot of things, mostly which tables (local/linked) and how many functions are being used.

[jo15765]

@aytee111 - they are linked tables from SQL Server. No functions are being used. Two are append queries and two are update queries.

[aytee111]

Yes, that will slow things down, even worse if they are depending on network availability.

[aytee111]

If the speed is a concern for you and if all the queries use the same table(s), you may be able to bring the data over first, put it in a local table and run your queries off that.