Its no help I'm afraid. but I ran into the same problem.
The only way round it is to restrict yoursef to built in
functions such as IIF, cStr, etc in queries. These mostly
work, although some of the less common ones don't
>-----Original Message-----
>Hi Everyone!!!
>
>I'd really appreciate if someone can help me with this
>issue. I have an Access database that has a module with a
>public function. I have a querydef whose SQL code is:
>
>Select fncMyCustomFunction() As Result, Max(lngMyID) As ID
>From dbo_tabMyTable;
>
>It works wonderfull if I execute it from Access. However,
>if I execute it from an ASP page (using ADO), I get an
>error that says that the function fncMyCustomFunction is
>undefined (or something like that). I searched in the
>Microsoft Knowledge database and it told me that it knows
>about it, and that's about it.
>
>Any help is strongly appreciated.
>.
>
|
Similar Threads
