In .adp project, Where is SQL Statement executed ?

[suntisuk]

Yesterday, I asked for Where is Query executed
(under .adp project). 2 MVPs replied, On SQL Server.
Thanks to Albert D. Kallal and Tom Ellison.

Today I just think "And what about SQL statement in my
program ? " If I also want it to be executed on SQL
Server side, What I have to do ? Does it depend on
database accesing method (ADO, DAO, DAO thru ODBC) ? Do I
have to write any specific keyword in SQL statement ?

TIA

 

[GreySky]

Sir:

In an ADP, Jet *is not loaded;* therefore, only SQL Server
can service SQL statements.

Have you noticed how you write T-SQL vs. "Jet SQL"?

If you use an .MDB, you can have a hybrid solution that
can run either locally (file/server mode) or on SQL Server.

David Atkins, MCP

 

[suntisuk]

Execuse me, Could you explain more. I not really
understand what you explain. I never programming in other
models than DAO before. So, I have only picture in my
mind that I have to write code like this :

Dim RS as Recordsets
Set RS = CurrentDB().OpenRecordset("SELECT * FROM TABLE;")

That's why I question What acessing model (ADO, DAO,...)
should I use. Is it still use the same statement as above
to access to T-SQL ?

Regards,
Suntisuk

 

[GreySky]

I apologize for my confusing response.

Use ADO for ADPs. But yes, all processing is done SQL
Server-side in ADPs (all queries requested via code are
sent to and then serviced wholly by SQL Server).

DAO is optimized for the Jet engine, and like yourself, I
mostly program (even today) in DAO. Quite frankly, I
enjoy using a hybrid approach to development (i.e., some
local user-only tables mixed with SQL Server views and
stored procedures [accessible through pass-through
queries]), which leverages the strengths of both
architectures with few limitations.

David

 

[suntisuk]

Oh! You needn't to apologize me, my question is not
clear. You are so polite. Unusually for me to found.

Thank you so much, David.