I hate reports. Trash Crystal Reports, Access Instead?

I am creating an app which requires a copius amount of complicated reports. These reports would be an absolute breeze to do in access, simply create a query that does all the work then base the report on that. Instead of wasting time with Crystal Reports, I'd love to be able to create an access query and then run an access report based on that query from within my VB app. Now I have code that allows me to run an access report, but it seems to require that access is open on the users machine at that time. Is there any way I can achieve what I need without opening access each time ?

Don't know if you have it, but VB 6.0 comes with a Data Report Designer that is modeled after the one in Access. It works in conjunction with the Data Environment, in which you can define connections to Access tables/queries - and it all works from inside VB. Might be worth a look.