Adobe Community: Message List - Query in an Access database executing a function defined in a module

Re: Query in an Access database executing a function defined in a module

forums_noreply@adobe.com — Mon, 03 Mar 2014 18:49:24 GMT

Yes, this is also the conclusion I came to.

I'm developing another solution.

Thanks.

Re: Query in an Access database executing a function defined in a module

forums_noreply@adobe.com — Mon, 03 Mar 2014 16:32:46 GMT

I believe that UDFs in Access can only be run inside of the Access runtime environment, and cannot be called through the JDBC/ODBC bridge that ColdFusion is using.

-Carl V.

Query in an Access database executing a function defined in a module

forums_noreply@adobe.com — Sat, 01 Mar 2014 17:31:13 GMT

Hi all,

I have an Access 2003 database in which some function is defined in a module.
I also have a query defined which calls this function with no problem.
Both the query and the function work well when the query is executed from Access.
But when I try to execute the same query from ColdFusion, I get an error claiming that the function is not defined.

Any Idea ?