🚀 go-pugleaf

Hello,

The following message describe my problem posted by someone else in another newsgroup. I cannot not (yet) find any solution for it. 

Using Access 2000 I have written a small VBA routine inside of standard module. I have also written a query that calls this routine to modify one of the columns in a table, ie. to strip punctuation characters from the column, eg.

select name, MyFunc([name])
from myTable
where name = "myname"

MyFunc is defined in Module1 as a function that currently returns its argument (will put in the stripping details later!), eg.

Public Function MyFunc(ByVal s As String) As String
    MyFunc = s
End Function

This all works fine if I run the query within the Access environment.

However, if I try to execute the query from ADO (with BCB6) 
I get the following error:

undefined function 'MyFunc' 

So, is it actually possible to call a user-defined function from outside of the Access environment, and if so, how????

Any suggestions are appreciated!