HOW TO CALL ACCESS FUNCTIONS EXTERNALLY THROUGH ODBC

[Kurtic20]

I have made user defined functions in Access that I want to call externally through ODBC. I am trying to emulate the same functionality that Oracle has with stored procedures, and replace them with the Access equivalent. These functions are used inside SQL queries. It works when I am working within Access, however, when called through ODBC I get a 'undefined function' error. Is there any possible way to get around this problem. I have tried everything I can think of...any help would be greatly appreciated.

Here is example code:

Public Function to_date(ByVal date_str As String, ByVal form_str As String) As String
to_date=Format(date_str, form_str)
End Function

SELECT STATE, to_date("12/10/1879", "yyyy-mm-dd&quot FROM SOME_TABLE;

Curtis Wesley
"Party on, dude."

 

[lameid]

Jet SQL is simply a component of Access that is usable through ODBC. Forms, reports, and modules are outside this realm. Unless there is some trick I don't know about you have to use some sort of Automation and give up on ODBC. I'm assuming your above example is over simplified and that you can't really just use format directly in the query.

 

[Kurtic20]

I can use the format function directly in the query, provided that I set up the module and tables correctly. Unfortunately, I have to go through ODBC. Is there anyway that this can be accomplished with a dll?
Curtis Wesley
"Party on, dude."