Access-Reports from vb.net

[smriti]

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