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

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


SELECT GetSomeInfo() AS MyLocalInfo;