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

[Claude1]

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 ?

[Carl Von Stetten]

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.

[Claude1]

Yes, this is also the conclusion I came to.

I'm developing another solution.

Thanks.