Undefined Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Well, I'm not sure, but I think that User Defined Functions are only available
within Access.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Undefined Function error - Complex 3
Undefined function 'concatenate' in expression 0
undefined function 'chr' in expresssion 2
Undefined function 3
Undefined Function DATE 4
Date expression in Query 4
Undefined function "Date" in expression 3

Back
Top