• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 21. Client/Server Strategies > Using Pass-Through Queries and Stored Pr...

Using Pass-Through Queries and Stored Procedures

It is important to remember that executing pass-through queries and stored procedures is much more efficient than returning a recordset to be processed by Access. Pass-through queries and the details of how they are implemented were covered in Chapter 20, “Client/Server Techniques.” The difference with pass-through queries lies in where the processing occurs. With pass-through queries and stored procedures, all the processing is completed on the server. When operations are performed using VBA code, all the records that will be affected by the process must be returned to the user's memory, modified, and then returned to the server. This generates a significant amount of network traffic and slows down processing immensely.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint