Modules in access

[pushpendra vats]

Hi!!
I have small query! I have created a small module in
access 2000.I want to call this module from visaul basic6.0
Is it possible .If yes then what is the procedure for that.

Thanks in advace

Pushpendra

 

[Alex Dybenko]

add a reference to access 2000 in your VB app, then make a proc with:

Private mAccess As Access.Application
Set mAccess = New Access.Application
mAccess.OpenCurrentDatabase "C:\my.mdb"
mAccess.run "=MyFunction()"

dont remember exact syntax for .run method, so please check online help