Web pages generated by MS Access and using user-defined functions

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.

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.

Unfortunately, there is no way to fix this problem: certain functions simply
aren't available from outside of Access.

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



"Frank Xia" <FrankXia@discussions.microsoft.com> wrote in message
news:23FEE77D-7594-43E0-9EC4-11A511DEF109@microsoft.com...
> Thanks, Brendan,
> I have the same problem as Stefen except my function is not a user defined
> function. It is a built-in function "FormatNumber". Is there any way to
> fix
> this? or I have to leave it based on your following information.
>
> Thanks in advance for your help!
>
> "Brendan Reynolds" wrote:
>
>> 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.
>>
>>
>>