There is a DTS package that runs and transfers data from MS Access 2000
file to MS SQL 2000 db.

The data source for this transformation is Access query which is
similar to a view in SQL Server. This query calls a function to return
a value for one of the resulting fields, somethign like

SELECT a,b,c, GetD(val1, val2) AS d


GetD() is actually the Access VBA function in one of its modules.
Apparently you can do this.

Now, when I run above query in Access itself it works fine. When I run
a DTS package step that uses this query as the source I get error
saying "Undefined function GetD() in expression".

Any good ideas?