I have a select query that contains a function defined in Access Modules. The query works within Access but fails when running from asp, whether I execute that select statement or execute the Access query.<BR><BR>It is the select statement<BR>select * from mytable order by StrToHex(field1)<BR><BR>StrToHex is the function created in Access Modules.<BR><BR>The error message is:<BR>Microsoft JET Database Engine error &#039;80040e14&#039;<BR>Undefined function &#039;StrToHex&#039; in expression.<BR><BR>It seems ADO Jet Provider does not care about what functions there are in the database Modules. Any help or workaround on this is greatly appreciated.