Accessing UDFs in MS Access Module from VB6
I m developing an offline application using VB6 & MS Access, which is in .Net/SQL Server 2000. I have converted all UDFs in SQL Server 2000 in MS Access and re-wrote those in MS Access `Module` section. Also i re-wrote all views of SQL Server 2000 in MS Access in the `Query` section. All my queries and views works fine in the MS Access environment. But when i create Recordset in VB6 and call a query containg UDFs [now in the Module of Access] it throws an error `Undefined Function`...
Kindly help me out to solve this issue.
This is urgent. so please help me..
Thanx in Adv.
Chaitanya S. Tembe
Cell: +91 98 208 31 42 1