How to Seek and Sort in the same ADO recordset

M

Mac

Because I need to specify the cursorlocation as aduseClient to sort it seems
to be
causing problems with my .Seek method on that same recordset in that module.
It is returning an error of "Current provider does not support the necessary
interface for index functionality.". How do I sort the recordset and seek in
the same module without errors?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort and Seek in the same recordset? 9
How to Sort a recorset and then Seek in that recordset (ADO)? 0
set unbound listbox recordset to sorted and filtered ADO recordset 0
Seek (ADO) finds same absoluteposition for two different indexes 5
Seek method - converting to FindFirst 8
ADO index/seek methods to linked AccDB tables 7
A theoretical question: how best to manage perpetual recordset needs? 24
Seek in Recordset not working. 2

Top