VB .NET having trouble with custom function in Access Query

[Phil5673]

I have a query written in Access 2003 that uses a custom function (VBA).

Another developer in the organization is trying to execute the query from VB .NET (using ADO .NET).

ADO .NET doesn't know what to do with the custom function.

We don't want to copy the custom function in VB .NET because we don't want to have to maintain 2 sets of code.

Are there any other options?

 

[CautionMP]

In VB.Net create a code reference to the Access database so the function will be available?

CMP

Funny thing about being unemployed, weekends don't mean quite so much, just means you get to hang out with your working friends. Primus