I'm trying to figure out if a user defined function inside a dll can be used within the Access SQL statement without creating a wrapper function in the module space. I know Access has it's VBA functions stored in a dll. These it is able to call without first creating a wrapper. Is it possible? please help!
Ex:
Access VBA function in dll
Select name, format("12/10/79", yy-mm-dd) from PERSON_TABLE;
User defined function in dll
Select name, to_date("12/10/79", yy-mm-dd) from PERSON_TABLE;
Ex:
Access VBA function in dll
Select name, format("12/10/79", yy-mm-dd) from PERSON_TABLE;
User defined function in dll
Select name, to_date("12/10/79", yy-mm-dd) from PERSON_TABLE;