Open MS Access form from QlikView

[Anonymous]

Hi All,

Trying to open a MS Access form from a QV dashboard, so that the user can update the DB from an app on Access Point. Has anyone managed to do this?

Thanks

[m_woolf]

You can do this with a vbscript macro:

sub OpenAccess

     Set ACApp = CreateObject("Access.Application")

     ACApp.Visible = True

     ACApp.UserControl = true

     ACApp.OpenCurrentDatabase "C:\Users\TestUser\Documents\Database1.accdb"

end sub