Is possible to open from QV a MsAccess file and run a macro?

[#1]

Hi, i only know how to open a excel file, but this time a need to open an access file and run a macro from it.

It's possible?

Thanks in advance

[Anonymous]

Hi

     Using following macro we can open the ms access

Sub OpenAccess

    set obj=createobject("word.application")

obj.visible = true

End Sub

Regards

Ashok

[m_woolf · Accepted solution]

This vba code is from Microsoft:

Sub AccessTest1()

      Dim A as Object

      Set A = CreateObject("Access.Application")

      A.Visible = False

      A.OpenCurrentDatabase("C:\My Documents\AccessAutomation.mdb")

      A.DoCmd.RunMacro "AccessMacro"

End Sub

[#4]

Thank you, from your code i only need to eliminate "Dim A as Object" and it works!