Microsoft® Office Access 2003 Inside Out

Working with Server Filters

As you learned in Chapter 19, when you specify a server filter, Access includes the filter in the request it sends to the server. The server selects the rows that meet the criteria in the server filter and sends only the requested data back to Access. Server filters are advantageous because they reduce the size of the recordset, fetching only the data the user needs to see. You can also set the Filter property on a report, but Access doesn’t apply that filter until it has fetched all the unfiltered data from the server. Using a server filter cuts down on the time a server must spend processing the recordset and eliminates the time that Access would otherwise spend applying the filter on your client machine. You can ...