[externally] invoking a user-defined function

[jadn]

Hello,
I wrote a Function ("funcFlush") and a Query ("qryFlush") that simply calls "funcFlush". If qryFlush is run in the Access IDE, the Function runs, but when I use ADODB to call the query, an error is returned 'undefined function "funcFlush" in expression'.

Why would this [user-defined] function be hidden from external code? Is there a security setting that can cause this? I tried the common fixes - like makeing sure VB\tools\"references" are healthy and verifying up-to-date drivers - but so-far have not identified the cause.

(Access 2000, Win2K)

Any help would be very-much appreciated!
Cheers.

 

[jadn]

... Apparently this is not, even theoretically, possible via ADODB.

If anyone here knows otherwise, please reply!

To quote another thread at

http://www.egghead.com:

"
Sorry, Stefen, the ability to use user-defined VBA functions in a query is a feature provided by Access, and is therefore not available when your queries are executed outside of the Microsoft Access environment.
--
Brendan Reynolds (MVP)
"

 

[Zion7]

jadn, I'm really not sure why it isn't working.
But I'm just curious, Using ADO, you're still calling from the iDE, aren't you?

As a recordset? As an ADOX view?
If so, can you show both codes?