Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2005

Tip: Looking for answers? Try searching our database.

view or pass-through

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
smk23 - 14 May 2005 15:51 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.