hi. im so lost now. teying to look fro a reason for this error but come up empty.

heres me problem, Im using MS access as my DB. and VB.net

i have a query in my DB that uses a USER-DEFINE FUNCTION...

If i open my query in the ACCESS,, it works fine.. it computes date as it was designed.

So last thing to do is Select the QUERY table in VB.net like this:


SELECT * from qryDates

NOTE that the qrydates uses a USERDEFINE FUNCTION Get_Date().


now my problem is it promtps : Undefined function 'Get_Date' in expression.


why it happens?
thanks...