I converted my access 97 database to access 2000, when I try to open a report with access 2000, it work fine, but with Visual Basic, the access windows open, but the report doesn't.
(I have VB 6.0 with Service Pack 5, I have the reference to the Access 9.0 object library in my application. All my application work fine, exepct for open a report.)
My code :
Dim acApp As Object
Set acApp = CreateObject("Access.Application.9" )
Dim path As String
path = CurDir & "\db.mdb"
.DoCmd.OpenReport "report1", acViewPreview
Set acApp = Nothing