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

Working with Server Filters

You should already be familiar with using filters in forms from working through the earlier forms chapters in this book. In addition to regular filters, Access projects also include the ability to apply server filters. Server filters function similarly to regular filters except they are applied before the recordset is retrieved from the server and sent to the form. When you apply regular filters in forms, Access first fetches the recordset from the server and then applies the filter on your client machine to limit the rows actually displayed in the form. Applying filters on the server side is advantageous because it reduces the load on the server and it cuts down on network traffic.

Although server filters are very advantageous, you can use them only when your form has a table or a view as its record source. You can define a server filter for a form that is bound to an in-line function, but Access ignores it. If you try to define a server filter for a form bound to a stored procedure, Access displays a warning message when you try to open the form: “A Server Filter cannot be applied to a stored procedure Record Source. Filter not applied.” Tables and views do not support parameters, so you cannot design a form that uses both parameters and server filters. As you’ll learn later in this chapter, parameters can be just as effective as server filters when you bind your form to a function or stored procedure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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