run report w/VB6?

[SWickstrom]

I have an Access data base with a very limited number of
users. Within this data base there is one report,
however, that a number of people could/should/would use.
Is there some way I could write a Visual Basic routine
outside of the data base that would allow someone to run
only this report?

 

[Douglas J. Steele]

Assuming the users will still have Access installed on their workstations,
you can use Automation to produce the reports. Check the following
references:

ACC: How to Use Automation to Print Microsoft Access Reports:
http://support.microsoft.com/?id=145707
ACC2000: How to Use Automation to Print Microsoft Access Reports
http://support.microsoft.com/?id=210132
ACC2002: How to Use Automation to Print Microsoft Access Reports
http://support.microsoft.com/?id=296586
ACC: Using Microsoft Access as an Automation Server
http://support.microsoft.com/?id=147816
ACC2000: Using Microsoft Access as an Automation Server
http://support.microsoft.com/?id=210111

If they don't have Access installed, I'm afraid you're out of luck.