Skip to main content
C
Claude1
Inspiring
March 1, 2014
Question

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

  • March 1, 2014
  • 1 reply
  • 794 views

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 ?

This topic has been closed for replies.

1 reply

Carl Von Stetten
Carl Von Stetten
Legend
March 3, 2014

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.

C
Claude1Author
Inspiring
March 3, 2014

Yes, this is also the conclusion I came to.

I'm developing another solution.

Thanks.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices