Hi Access experts,

I would like to retrieve data from Access using Excel VBA through ADO.
This was successfully done in the past until a user-defined function
was added to one of the fields in the Access query. On Access, the
query can run successfully. On Excel, an error "Microsoft Access
Database Engine -> Undefined function in expression" is returned.

Has someone encountered similar problem before? Any workaround? I
think using user-defined function in queries should be quite common
because it is so useful.

Thank you.

On 04/01/2012 13:35:11, Lane wrote:
Yes and the most annoying one is that Excel doesn't recognise Nz() function,
but fortunately it does recognise IsNull() so there is sometimes a work
around

Phil

Lane wrote:
Yes. Everyone who has tried.

from external apps.
http://support.microsoft.com/default...98&Product=acc

Note: the article seems to imply that a registry change can enable external
apps to use udfs, but I've never seen anyone successfully do it.

Thank you for the replies. Now, I know that this is a limitation of
Access. This is so inconvenient. If UDF could be used, a lot of work
could be done at the Access side.

On Jan 5, 2:55*am, "Bob Barrows" <reb01... (AT) NOyahooSPAM (DOT) com> wrote:

Yep, it's one of the big factors in deciding to move to SQL Server backends.
SS stored procedures are so much more powerful than the Jet equivalent.

Lane wrote:
..