Make table runs longer from VBA

[Kowalski]

Hi
I have a Make-Table query, that pulls info from a number of subqueries and tables. When I run the query normally, it takes about 1 second to create and populate the table. But when I tun the same query via VBA like:

CurrentDb.Execute "MyMakeTableQuery"

then it takes about 10 seconds.

The information is coming from SQL Server.
Any possible reason for this?

 

[namliam]

Perhaps the query is being executed by your client instead of your server?

Try creating a normal select query that pulls all your data, normaly in the database... Then a simple createtable query on top of that....

Why use a create table for such a short query in the first place?