Crystal Report Generator in VB6

We require a small stand alone application that provides end users with report generation facilities connecting to an MS Access database that is password and not workgroup protected. We have Crystal reports 10 and therefore the runtime licences so would prefer the solution to use Crystal Reprts 10. Also have the need to hide some table from viewing by the end user, system files etc. We are not particularly impressed with an ODBC solution due to its complexity to setup and maintain.? The ability for users to save the report template for re use, if these files can be compiled even better. We are open to other solutions than crystal, if appropriate but costlty redistributable licences are out of the question. Any further info please send me a message - Thanks Chris