devxlogo

Use Find Function of the DAO With Indexed Fields When Working With ODBC Data

Use Find Function of the DAO With Indexed Fields When Working With ODBC Data

Find function is used to locate a particular string in a dynaset or snapshot type recordset using a comparison operator. In general, it is better to create a new query that retrieves the records that is required instead of using Find function in the DAO recordset. This is true especially with ODBC data. On ODBC data, you should use Find only on indexed fields. It is otherwise more efficient to open a new recordset using a SQL statement with an appropriate WHERE clause. Always remember that smaller the set of records you have, the more effective Find will be.

See also  Why ChatGPT Is So Important Today
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist