How do I use MSAccess Functions in SQL?

[MapMan]

I have some string functions that I developed in Access that I want to use in SQL. I've read that I can create a library (dll) and have SQL call it using the (USE LIBRARY) function. But, everywhere I've tried the USE LIBRARY statement I get a "invalid statement near USE" error.<br>
<br>
I'm very frustrated about this. Anyone got any suggestions?<br>
<br>
Thanks,<br>
<br>
MapMan

 

[bigfoot]

You need to compile the dll witth somthing like C++ and it's then called an Extended Procedure.<br>
Hope this helps.

 

[MapMan]

Thanks BigFoot. I'll see what I can create.<br>
<br>
MapMan