MS Access stored function

[thickbrain]

I created a function and saved it as a module in MS Access.

When I run the function in MS Access I get the expected result but when I run it in SWFKit I get a function undefined error.

ex: "SELECT getGUID() as myID;"

But, if I use a built-in MS Access function such as Now() in SWFKit then I get the date as expected.

ex: "SELECT Now() as myDate;"

How can I get my custom function to work from SWFKit?

[SWFKit]

http://www.functionx.com/vbaccess/Lesson23b.htm

[thickbrain]

The link you gave me show how to create procedures from ADO to store regulare SQL statements but not how to store a VB script.

Basicaly, I have a piece of VB code in a module that generates a GUID. It's working find when used within Access but not when called from ADO.

How could I store that VB code and reuse it from ADO?

[SWFKit]

No, ADO cannot call vb code.