Running Reports from VB without having MSAccess97 installed

[nidgep]

Hello database experts!

I recently posted a message regarding the running of reports from VB6
against an Access 97 database.Thankyou to all whom helped me.
The reports are all finished now and the next stage of the program is due
to be shipped shortly.

As MS Access report experts I thought that I would post this message here as well as in the Vb forum.

So...here goes..........

Quite a few of the users do not have MS Access 97 installed or even MS
Office, and I have tried to get the reports to run by installing the
MSACC8.OLB which is the component referenced with the VB application.
When attempting to create a setup program, a message appears saying that
dependency information for the MSACC8.OLB file cannot be found.

I then attempted to create a dependency file and copied it to the location
of the MSACC8.OLB.

The setup program now ran Ok. The setup ran OK, but the reports cannot be
run due to ActiveX component cannot create object error.

Is there anything that I can do to get around this problem without having
to install MS Access 97?
Can I obtain a runtime version of Access97 (version 8) and if so will this
solve the problem?

Please help!!


Nigel.

 

[Guest_imported]

You can get a 3rd party software piece called VSReports that works pretty well. Its made by componetone. Check it out at

http://www.componetone.com.

Hope this helps