Originally Posted by
Ajax
sql is a different language to vba and can only reference local vba modules. So not aware of any other way than the way you are doing it
What am I missing then? Worked for me. In db2 I created a reference to db1.
db1 contains a function
Function ReturnValue() As Long
ReturnValue = 5
End Function
In db2, I have a query with SELECT returnValue() as Test;
It returns 5.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.