Hello!
I´m attached to a SQLServer 7.0 database.
I' m not able to pass more than a field for search in a criteria string
for the ADO recordset find method.

Imagine a recordset which has the contents of a table called books,
two of its fields are called idbook and bookname.
I would need a thing like:

rs.Find "idbook>2 and bookname like 'the%'"

When i use more than a column(field) for tyhe criteria string, i have an error
telling "the application is using wrong arguments,or out-of-range arguments". Always the same error number, 3001


Can anyone give me a solution for this?

Thanks for your help