Access database through VB6

I have a VB6 application that I would like to have the ability to open and view an Access database report and print it.  Is there a way to do that?

sjmmajorAsked:
Who is Participating?
 
_agj_Commented:
Set a reference to teh MS Access library in references:

sub makeRPT()

Dim acApp As Access.Application
Dim rpt As Access.Report

acApp.OpenCurrentDatabase "DBPath"     'path of db to open
Set rpt = acApp.CreateReport(acApp.CurrentDb, ReportTemplate)    'ReportTemplate is name of rreport tmplate.

rpt.Print

end sub
0
 
sjmmajorAuthor Commented:
Does the person have to have access.exe on their computer?
0
 
JNSTAUBCommented:
no , you may use ADO and cristal report without access on the client computer, a lot of dll will be  provide with the package that you will create.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.