Access Reports without Access

[Jim Satterfield]

I have a program written in VB6 with an mdb file backend on the server. I
have reports that I create on my computer that has Access installed that I
need people on other computers to be able to print. The problem is the old
issue of Access resetting the paper size if it happens to run out of legal
paper. The code that I've seen and used to fix this problem depends on being
able to create an instance of the Access app. This of course does not work
on a PC that doesn't have Access installed. Is there a way to
programmatically do this from VB6 without the Access application? I haven't
been able to find one.

[c***@yahoo.com]

On Sep 20, 8:41 am, "Jim Satterfield"

Post by Jim Satterfield
I have a program written in VB6 with an mdb file backend on the server. I
have reports that I create on my computer that has Access installed that I
need people on other computers to be able to print. The problem is the old
issue of Access resetting the paper size if it happens to run out of legal
paper. The code that I've seen and used to fix this problem depends on being
able to create an instance of the Access app. This of course does not work
on a PC that doesn't have Access installed. Is there a way to
programmatically do this from VB6 without the Access application? I haven't
been able to find one.

Try DataDynamics Active Reports
www.datadynamics.com

These reports work like access so you'll be pretty comfortable with
them. You will have to intall a few dlls on the local machine of
course.

There is even an Access to ActiveReporst upsizer available on the net.