Show Reports

[shahab]

I have reports made in MS Access. Is there some way to show MS Access reports using vb...

[Hack]

'Set A Reference to MS Access Object Library
Private Sub cmdPreview_Click()          
           Set Axs = CreateObject("Access.Application")
            Axs.Visible = True
            Axs.RunCommand acCmdAppMaximize
            Axs.OpenCurrentDatabase ("c:\yourdb.mdb")
            Axs.DoCmd.OpenReport "TheReportName", acViewPreview
            Axs.DoCmd.Maximize
            Axs.Quit
End Sub

[shahab]

thanx hack, but the problem is that whether this will work on a system where MS Access is not installed.

[shahab]

anyone pls???????