DAO - > ADO: useing Indexes defined in Access

[Wayne Jones]

I am converting a database written to use DAO to now use ADO. In DAO I was using an index that included two fields that has already been setup in the Access DB. Is there a way to use this in ADO. If not what is the equivalent in ADO, I've only found the Find method, that doesn't seem to allow more than one field. If anyone has any advice/code/musings they would like to offer it will be much appreciated.

TIA Wayne


[Edited by Wayne Jones on 11-12-2000 at 11:56 PM]

[Wayne Jones]

Ok I should have looked more closely at the Help file but its so cumbersome. Anyway I found I can combine the sort and Find methods to achieve what I want but now I get an "Invalid use of property" error on SORT in the following code,
rsManning.CursorLocation = adUseClient
rsManning.Open sOpenRecSet, dDBcnn, , , adCmdText
rsManning.Sort "Hospital ASC, WorkCentre_Code ASC"

can someone tell me what I'm doing wrong.

TIA Wayne