hai,
Go through this.I think its useful to you.
ADO 2.1 incorporates useful but unexciting additions, including a new Recordset Seek method and an Index property to improve search performance on large table-type recordsets. However, the new Seek syntax differs from DAO's Seek method. Instead of DAO's strange rstTable.Seek "{=|<|<=|>=|>}", varKey1[, varKey2[, varKeyN] convention, the ADO Seek method uses rstTable.Seek avarKeys, lngOptions, where avarKeys is a Variant array of values to compare in each index column, and lngOptions is an enumeration of adSeek... constants that correspond to DAO's arithmetic operators. For example, adSeekAfter serves as the equivalent of the > operator. ADO's developmentally challenged Find method proves almost as fast as DAO's, unless you have an extremely large table. Unfortunately, ADO 2.1's Find method still doesn't handle the compound multifield WHERE clause arguments of DAO's Find method, and workarounds to handle multifield ADO Finds prove laborious. Microsoft blames Find's limitations on the current OLE DB specification.