USING SEEK IN ADO WITHOUT INDEX

[MALICKA]

Is it possible to use seek in ADO wihout creating index

i have problem in seek when i use within function

my code :
Public Function RecordFound(cKey As String, cSearchValue As String) As Boolean

FindCrit = cKey & " = '" & cSearchValue & "'"
rs.Seek cSearchValue, adSeekFirstEQ
( codes)

End Function

 

[BlackburnKL]

ADO recordsets also have a FIND method and a FILTER property which may provide what you need. In my experience with it, FIND is faster than FILTER (but SEEK should be faster than either of the other two).

 

[MALICKA]

Hi BlackburnKL
Yes ofcourse i use find now
but i want to change to seek for faster as there are more than 20000 record to use

 

[MALICKA]

Is any one out there to help me
How to use seek in ADO
now i use find it's bit slow

 

[slhslm]

hi
go ahead 2

http://www.vbforums.com

sure you will get answer