Can a query internal to an A2K database which calls a custom function be called from an external program?

When I try to execute the query from another program (ADO command / stored Proc)
I get the error "Undefined Function 'GetSomeInfo'



This is a simplified version of What I am attempting to do...

I have a module (Module1) which contains a function and a Query (Query1) which calls the function


Module1
-------
Option Compare Database
Option Explicit
Public Function GetSomeInfo () As String
GetSomeInfo = "My Info Goes Here"
End Function


---------------------------------------

Query1
------
SELECT GetSomeInfo() AS MyLocalInfo;