Running Access Module code

[Mark Sreeves]

Is it possible to execute code in an Access module from a VB front-end?

(Please let it be YES!)

------------------
Mark Sreeves
Analyst Programmer

[email protected]
A BMW Group Company

[Clunietp]

Add reference to Microsoft Access 8/9 Object library

This executes a sub in an MS Access module:

Be sure your method (in the Access module) is declared as PUBLIC

    'declare objects
    Dim axs As Access.Application
    Set axs = New Access.Application
    
    'open database
    axs.OpenCurrentDatabase "C:\Nwind2k.mdb"
    
    'call PUBLIC helloworld subroutine
    axs.Run "HelloWorld"
    
    'release object
    axs.CloseCurrentDatabase
    Set axs = Nothing

HTH

Tom

[JHausmann]

I've done it in Excel, I'd expect the anser to be yes for Access.