Sorry, Stefen, the ability to use user-defined VBA functions in a query is a
feature provided by Access, and is therefore not available when your queries
are executed outside of the Microsoft Access environment.
--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com
The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
"Stefen Percoco" <Stefen
Percoco@discussions.microsoft.com> wrote in message
news:9FF0975A-2628-44C2-A437-80028CB3782C@microsoft.com...
> Hi.
>
> I have a MS Access database with a query using a user-defined function. I
> have created a web page based on this query. When accessing the web page
> from
> inside MS Access, everything works fine but when I try to access the web
> page
> from outside MS Access, I receive the message : "Data provider failed
> while
> executing a provider command." and then "Undefined function
> 'my_user_defined_function_name' in expression".
>
> Is it a way to avoid this problem ?
>
> Thanks in advance.
>
> Stefen Percoco.