Can anyone tell me...
What's the difference between
1) linking an SQL table to Access and running queries against the linked table, and
2) creating pass-through queries to run against the SQL database/table?
I have been told several times that if you do "1)" that the entire recordset is NOT being processed locally, and that it is being processed server-side, and that at this point you therefore have a client-server environment. Is this true?
Some other questions are, Is the effect of "1)" and "2)" the same? Are there performace issues involved when comparing the two methods? Does using the MS Access SQL writer allow for a more flexible coding environment?
Any insight you may have is appreciated. Thank you for your help.
Mike Kemp
michael.kemp@gs.com
What's the difference between
1) linking an SQL table to Access and running queries against the linked table, and
2) creating pass-through queries to run against the SQL database/table?
I have been told several times that if you do "1)" that the entire recordset is NOT being processed locally, and that it is being processed server-side, and that at this point you therefore have a client-server environment. Is this true?
Some other questions are, Is the effect of "1)" and "2)" the same? Are there performace issues involved when comparing the two methods? Does using the MS Access SQL writer allow for a more flexible coding environment?
Any insight you may have is appreciated. Thank you for your help.
Mike Kemp
michael.kemp@gs.com
