O'Reilly logo

Microsoft® Office Access 2003 Inside Out by John L. Viescas

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required