ADODB objects with SQL Server

[Jonathan Blitz]

I have an Access project that works with an SQL Server database.

When I use an ADODB object to perform an SQL command is the command sent to
the server for execution or is it executed in Access by fetching the rows to
Access?
This is very important as in some cases the SQL command is simply a copy
from one table to another and it seems stupid to do that by pulling the
lines into Access and back.

If it is done by Access then what is the correct way to do it? Is the only
way to create a stored procedure or is there a way to tell Access to send
the command to the Server for execution?

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."

 

[May]

the command will execute on SQL Server, unless you need to
view the data, then SQL Server will send the data back to
you. and that's why you have max reocrds button on each
form

MCP in Access and SQL Server