Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
wood_murray
New Contributor

Open MS Access form from QlikView

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

1 Reply
mwoolf
Honored Contributor II

Re: Open MS Access form from QlikView

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