running a function from access

[c@lle]

I'm trying to run a function called 'TransferData' from the module 'modTransfer' in an access database.

I have a connection the this database (via adodb.connection)
using following source string :
*
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=d:\catfax\whcatfax.mdb"
*

I'm able to transfer data from VB to tables in this database. Is it possible to execute the above mentionned function via this connection?

I've tried: connection.execute ("TransferData")

Is there a way to execute the function????

[Clunietp]

here is a way to do it, but it does not use ADO:

http://www.vb-world.net/ubb/Forum3/HTML/002809.html

[c@lle]

to clunietp : thx