Re: Undefined Function ... in Expression

message from Brendan Reynolds on 5 May 2004

Most certainly you could adapt them in Access - if you were using Access!
:-) But when you use a VB6 front end and an MDB database, you're not
actually using Access - you're using the Jet database engine.

There are many built-in functions that can be used in Jet queries. There's a
list at the following URL, but my own tests so far differ somewhat from that
list, and the list does not distinguish between functions that work both
within and outside of the Microsoft Access environment, and those that only
work within that environment, which is why I'm continuing with the tests.

http://support.microsoft.com/default.aspx?kbid=294698

You may be able to replace some of your Oracle functions with these built-in
functions, or with expressions that combine two or more built-in functions,
but you can't use *user defined* VBA functions in a Jet query when it is
executed outside of the Microsoft Access environment.

Stéphane Le Tréis replied to Brendan Reynolds on 5 May 2004

Thank you once again for your time, I think I understant a bit better how
the Jet database engine works.

I'll try to rewrite my functions with the built-in ones.

Bye :-)

"Brendan Reynolds" <brenreyn at indigo dot ie> a écrit dans le message de
news:%23m5MKapMEHA.3712@TK2MSFTNGP10.phx.gbl...

Archived message: Re: Undefined Function ... in Expression (Microsoft Access)