T
Todos Menos [MSFT]
a) no; SQL Server does _NOT_ do the same thing on a linked table as
ADP. ADP returns the results; MDB does a SCAN in most situations.
b) MDb doesn't support triggers == MAJOR REASON TO NEVER USE MDB FOR
ANYTHING ==
c) ADP allows simple binding to a sproc _WITH PARAMETERS_ that is
completely superior to Access MDB parameter queries. If you've got a
sproc parameter named '@txtplu' it will bind to the control txtPLU.
NO CODING NECESSARY
with MDB if you want to use a form on a sproc; it requires a sql
passthrough and about 100 lines of code
TRY ARGUING WITH THE FACTS, KID
ADP. ADP returns the results; MDB does a SCAN in most situations.
b) MDb doesn't support triggers == MAJOR REASON TO NEVER USE MDB FOR
ANYTHING ==
c) ADP allows simple binding to a sproc _WITH PARAMETERS_ that is
completely superior to Access MDB parameter queries. If you've got a
sproc parameter named '@txtplu' it will bind to the control txtPLU.
NO CODING NECESSARY
with MDB if you want to use a form on a sproc; it requires a sql
passthrough and about 100 lines of code
TRY ARGUING WITH THE FACTS, KID