1 Reply Latest reply: Aug 7, 2017 11:05 AM by m w RSS

    Open MS Access form from QlikView

    Murray Wood

      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

        • Re: Open MS Access form from QlikView
          m w

          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