can i call a udf from access?

[chutney66]

hi there

i've got a adp front end with a sql server back end. i know i can call a stored procedure from code, but can i call a udf from code. i've tried with no luck yet.

any help much appreciated

 

[SQLSister]

CAll the UDF in a stored proc

"NOTHING is more important in a database than integrity." ESquared

 

[chutney66]

thank you for your fast reply

Does this mean i cant call the udf directly?

 

[SQLSister]

I can't imagine that you could because direct SQl from Access runs through the Access jet engine which does not support UDFs

"NOTHING is more important in a database than integrity." ESquared

 

[chutney66]

I thought if i was using an adp front end, this didnt use jet.

 

[AlexCuse]

I don't know anything about adp's, but you should be able to use the udf in a pass-through query as well.

Hope this helps,

Alex

Ignorance of certain subjects is a great part of wisdom