Seek Method

[comart]

I want to use the Seek method (rather than the find method) with an Access database. I get an error message stating that the provider is not capable of performing the operation. Doesn't access support the seek method? If not, why?

[dfwade]

Seek only works on an indexed field and you must set the index field before issueing a seek. Caution: Seek is fast but is not terribly portable to other databases.

[comart]

I indexed the field I'm seeking, and it still didn't work. Is access one of those databases that doesn't support seek?

[phunkydude]

you need to make sure that you're using the correct index from your code
Dim rs as ADODB.Recordset

'recordset already instantiated and populated
rs.Index = "IndexName"
rs.seek Value

[comart]

What is value?

[phunkydude]

Value is the field.value you are trying to match, whatever it is you're seeking.