Dear all

Can anybody Help me how to create and set 'Index' and use
'Seek' Command in ADO RecordSets. I have a table with 3 indexes and
i want to change index orders with respctive of my given conditions.
Secondly, how will i check whether the recordset is opend or not.
Because, i executed a statement at the first time its worked without any
error but while execting the second time gives me error that 'ADODB record
set operation is not allowed when the object is open...'. Then i just
add a statement at the end that 'Recordset.Close'. But sometimes
its giving same error when i calling from different Procedures.

With thanks and Regards
Abdulla