O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Searching Records

The following scenarios are available for searching recordsets:

  • Using a SQL query with a WHERE clause to constrain the recordset

  • Searching with the Find method

  • Setting Filter conditions

In general, you should always use the first scenario for working with recordsets. It is always faster and easier to select Access records based on a query or a SQL character string.

However, there are exceptions: For example, to minimize network traffic, it can be useful to open a recordset with a static cursor and import all data to the client, then search and filter the data in the recordset. This section does not address the option of using a SQL command to constrain a query’s resultset. Instead, we introduce the methods for searching and ...

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