Access 97 reports

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.

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

Code:

---

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