Make Reports Into There Own File Format Like .RPT
Microsoft Access is pretty nice when it comes to reporting. The biggest drawback with reporting in a production environment is that it is bound to the application... i.e. many times customers want a small change on reports and you have to distribute a whole new version just to make a minor change that may have only taken 5 minutes! You should give Access report the ability to be exportable into a file format like SSRS or Crystal... this way we can edit and replace reports without having to re version the full applicaton.
You can distribute a modified report, form, etc. by exporting the object(s) to a blank accdb, then import to the production application.