We at my company are new to SQL Server and have a question<br>regarding the use of MS Access and SQL Server. Our users<br>want to perform their own queries in Access using SQL<br>Server tables. We understand that it is quicker to use a<br>pass through query. Is this true? I guess my real question<br>is how best to proceed when using Access to query SQL Server<br>tables? Any help would be greatly appreciated!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Pass Through Query 1
- Thread starter RangerFan
- Start date
-
1
- #2
On many queries, if the joins are indexed fields and and the criteria and or sort fields are indexed, a standard access select query should work just as fast as pass-thru, the odbc driver is smart enough to have the server process the query, instead of having Jet do it, which can happen on more complex queries. Update and other action queries might not be as fast, since often an acknowlegement is sent back to the client for each record processed. Some odbc drivers have an option to do 'block' fetching, where it will Ack blocks instead of each record. <br><br>Also, Pass-thru select queries are not updateable, which may or may not be an issue.<br><br>--Jim
elizabeth,<br>Sorry...Ack-nowledge...the server sends a packet saying the record was updated, deleted, added, etc...if the fetch is a 'For Update of' fetch, for instance, and fetches a block of records to update, just one 'ack' is sent to acknowledge the entire block.<br>--Jim
- Status
Similar threads
- Locked
- Question
