>As we knows that Find method can be used only for one criteria, and we can not use seek method if we use sqloledb as the provider, so what should I use for finding a record by using more than one criteria?.. any way I don't want to use "Select .. blah blah" statement because I think it will be use high memory resources and the speed will go slow down when it load the large size of table.. any body can help me or give me the best solution for this case .. please?
>
>Thank you in advance for any suggestion or idea..
>
>Best regards
>Winan

You can use a filter to apply multiple search criteria. Something like this:

myRS.Filter = "field1='blah' and field2='blahblah'"

HTH