Access 97 reports

[Lieu]

hello,

I wonder if it is possible to use Access 97 reports from VB 6 front end. If it is, please provide sample code.

Thank you very much.

[Edneeis]

You can but unless the target machine has Access on it then it wont work. You just have to subclass Access.

Dim appAccess As Access.Application
Set appAccess = New Access.Application

appAccess.DoCmd.OpenReport "Name of Report", acViewNormal
appAccess.Quit

set appAccess=Nothing

Oh by the way make sure you reference the Microsoft Access 8.0 Object Library first