> Hi,

> 

> 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 (within a web page or a 

VB 

> app), I get an error saying:

> 

> [Microsoft][ODBC Microsoft Access Driver]undefined function 'MyFunc' in 

> expression

> 

> If I modify my query to use a built in function, such as Lcase$(), it 

> works fine.

> 

> I have also tried this without going through ODBC (using OLEDB from 

Visual 

> Basic) without success.

> 

> 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!

> 

> Lips.

> 



Hi,



I have the same problem. Did you found a solution ?



Thanks