Hi,
I need to display ms-access report from my vb.net application.
Can any one guide me to do this?
I did using the following code but its opening ms-access database.
Dim oAccess As Access.ApplicationClass
oAccess = New Access.ApplicationClass
Dim Report1 As Object = "Table1"
Try
oAccess = CreateObject("Access.Application")
oAccess.Visible = False
oAccess.OpenCurrentDatabase("F:\Execute.mdb", True)
oAccess.DoCmd.OpenReport(Report1, Access.AcView.acViewNormal, True)
oAccess.DoCmd().Quit(Access.AcQuitOption.acQuitSaveNone)
System.Runtime.InteropServices.Marshal. _
ReleaseComObject(oAccess)
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
oAccess = Nothing
Is there any alternate way?
Thanks
I need to display ms-access report from my vb.net application.
Can any one guide me to do this?
I did using the following code but its opening ms-access database.
Dim oAccess As Access.ApplicationClass
oAccess = New Access.ApplicationClass
Dim Report1 As Object = "Table1"
Try
oAccess = CreateObject("Access.Application")
oAccess.Visible = False
oAccess.OpenCurrentDatabase("F:\Execute.mdb", True)
oAccess.DoCmd.OpenReport(Report1, Access.AcView.acViewNormal, True)
oAccess.DoCmd().Quit(Access.AcQuitOption.acQuitSaveNone)
System.Runtime.InteropServices.Marshal. _
ReleaseComObject(oAccess)
Catch ex As Exception
MessageBox.Show(ex.ToString)
End Try
oAccess = Nothing
Is there any alternate way?
Thanks