Undefined Function

T

Tom

My user function works create when I pull up my query directly in Access.
When I run the query from my ASP page, I get Undefined Function.
My user function is converting a column and returning a value in the result
set.
I am not using the function (at this point) in a where clause.
However, I will need to create another similar function for use in a where
clause.
What am I forgetting???

TIA
 
J

John Spencer (MVP)

Well, I'm not sure, but I think that User Defined Functions are only available
within Access.
 
D

Douglas J. Steele

That's correct. When you're running queries from outside of Access, you're
strictly going through the Jet Engine, which doesn't know anything about
user-defined functions.
 
Top