Thank you Andrew,..
Yes ...right, that is exactly what i mean, if based on "comfortable", i very comfort to use SP on the server and use Pass Through Query to execute the SP.
Especially for the process that retrieving records to the client, but im not sure it's a good choice method for other process like Insert/Delete/Update...i suggest it will be the more SP then the more load/task on the server side. But i still consider that method (SP+PTQ) for DML statement just because my knowledge from many articles about by passing JET/ACE is good choice (i'm sure it doesn't mean JET/ACE is bad, just explaining there is more efffective/efficient technique).
So to make it more simple now i have conclusion (based on server side load) that for Insert/Delete/Update i will use ADO...thank you Andrew.
Regards
Hendra Agestha
--------------------------------------------
Pada Sel, 4/3/14, yahoo@craven.de <yahoo@craven.de> menulis:
Judul: [MS_AccessPros] RE: All processes based on Sql Server Stored Proc.
Kepada: MS_Access_Professionals@yahoogroups.com
Tanggal: Selasa, 4 Maret, 2014, 3:49 AM
Hi Hendra,
that's a deceptively complex question you have there...
Access does an amazingly good job of creating it's own
CRUD/SELECT/INSERT/DELETE/UPDATE SQL Commands based on its
knowledge of the things on/in your forms/recordsets and the
SQL Server behind them. I typically find that making Access
use Stored Procedures to do standard operations like SELECT,
UPDATE, oder DELETE is more effort on the SQL side than it
is worth. My one *major* exception to this would be if you
have specific user rights issues which are (my opinion)
going to be easier to handle on the SQL Server side than in
Access.
The answer for you will depend on several factors, how
comfortable you are letting Access make decisions for you,
how comfortable you are generating and maintaining the
multiple Stroed Procedures you are going to need to cover
the most important (or all) eventualitites, and how
comfortable your SQL DB Administrators are with the load
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar