Access-Reports from vb.net

smriti

Well-known member
Joined
Jan 7, 2005
Messages
54
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
 
Back
Top