Calling a Access 97 macro from VB

[JohnSmith]

I am using Visual Basic 6.0 and I created a macro in access 97 called tester.

By clicking on a cmd button how can I run this macro from my Visual Basic?

[Beacon]

Look into using the Microsoft Access Object reference!

You'll be able to do it through that!

b

[bobp]

perhaps this will be helpfull.....

Set rAcc = CreateObject("Access.Application")
 
rAcc.OpenCurrentDatabase (your_database_path)
 
rAcc.DoCmd.OpenModule "Module1", "SetStartupProperties"
rAcc.Run "SetStartupProperties"

Where "SetStartupProperties" is a Macro in Module1 of your Access database.

Don't forget to set reference to Access in your project.