TechNote (Archived)

ADODB.Recordset error '800a0bb9'

Issue

---

Applying certain filters to ADO recordsets can generate an error of the type:

"ADODB.Recordset error '800a0bb9'. The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another".

Reason

---

This error can occur when the ADO filter syntax has been structured with OR clauses within parentheses and AND clauses without parentheses. For example, the following filter structure returns the 800a0bb9 error:

(Team = 'Temple' OR LastName = 'Greer') AND FirstName = 'Lynn'

Solution

---

Create the ADO filter so that OR clauses are not grouped within parentheses as parts of a larger AND clause.

The following filters do not generate the '800a0bb9' error:

(Team = Temple AND LastName = 'Greer') OR FirstName = 'Lynn'
(Team = Temple OR LastName = 'Greer') OR FirstName = 'Lynn'
(Team = Temple AND LastName = 'Greer') AND FirstName = 'Lynn'

Search Support

---