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?
Printable View
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?
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.
I indexed the field I'm seeking, and it still didn't work. Is access one of those databases that doesn't support seek?
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
What is value?
Value is the field.value you are trying to match, whatever it is you're seeking.