JET 80040E14 error

[David Whitson]

Can anyone explain why I can't use the Replace() function
in ADO using the JET 4 PROVIDER but I can use the same
SQL statement in Access 2002? I get a 80040E14 error -
Undefined function 'Replace' in expression.

SQL Example: Select sDesc From Lookup Where Replace(trim
(lcase(sDesc)),chr(32),chr(0)) = 'testitem'

 

[Van T. Dinh]

DAO is built specifically for JET Database which can utilise the Expression
Service to interpret and pass the Access function back to Access for
execution. ADO is a generic programming interface which add another layer
in the process and therefore, cannot use the Expression Service to pass the
Replace function back to Access for Execution.

That's what I think, anyway.