Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error on Query which used User-Defined Function

0 views
Skip to first unread message

Mann

unread,
Apr 12, 2005, 10:05:01 PM4/12/05
to
Good Day!
I created a Query which used a User-Defined Function I also created. It runs
smoothly while Im inside the MS Access. The BIG problem occurs when Im trying
to call the Query from inside my VB Application - it was like saying that the
User-Defined Function can't be found or unknown. How can you help me fix this?

Thanks!

Douglas J. Steele

unread,
Apr 13, 2005, 1:17:50 PM4/13/05
to
Sorry, but you can't use user-defined functions against a Jet database if
you're running the query from outside of Access.


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Mann" <Ma...@discussions.microsoft.com> wrote in message
news:C281F270-54A7-4376...@microsoft.com...

vittorio

unread,
Mar 31, 2008, 6:53:00 AM3/31/08
to

"Douglas J. Steele" wrote:

> Sorry, but you can't use user-defined functions against a Jet database if
> you're running the query from outside of Access.

this is true for other built-in functions like nz.

vittorio (http://www.morzello.com)

0 new messages