Is there any performance benefit to using a SQL view over an Access
pass-through query when using SQL server as the backend?

Signature
sam
Douglas J. Steele - 14 May 2005 16:04 GMT
I think the most efficient would be for the pass-through query to call the
SQL view.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Is there any performance benefit to using a SQL view over an Access
> pass-through query when using SQL server as the backend?
Ofer - 14 May 2005 19:30 GMT
The main benefit you get by using sql view over pass thrugh is that you can
use the view with the stored procedure you will write in the sql server,
other wise it works the same. a pass-through query performance is just like a
view, that the point of it, it will do the process in the server instead of
the working station, but you cant use the pass-through query in the stored
procedures.
> Is there any performance benefit to using a SQL view over an Access
> pass-through query when using SQL server as the backend?
Ofer - 14 May 2005 20:00 GMT
Also incase you need to use that query/view from fiew places then it better
to create a view, that way you need to maintain it once, in one place with
link to all the db used, that way if you need to change it you don't have to
change it in all the db.
> Is there any performance benefit to using a SQL view over an Access
> pass-through query when using SQL server as the backend?
Ofer - 14 May 2005 20:21 GMT
Also if you want to use a view within view.
> Is there any performance benefit to using a SQL view over an Access
> pass-through query when using SQL server as the backend?
Sylvain Lafontaine - 15 May 2005 01:11 GMT
You can use Views as RecordSource for a form. See
http://support.microsoft.com/kb/q209123/ if you want to have an updatable
view.
For SQL pass-through, the situation is a little more tricky: you must first
create an ADO or DAO recordset and then link it to your form. See
http://support.microsoft.com/?kbid=281998 for exemple.

Signature
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
> Is there any performance benefit to using a SQL view over an Access
> pass-through query when using SQL server as the backend?