It's actually very easy to do and in my case I recommend it to my customers.
You create a new database, link the replicated tables to it and let them
loose on creating reports to their hearts desire.
I give my users their own "play" front ends (depending on skill and
authority what tables they can view, add, edit and delete), where they can
create queries, reports and the like. Once they are happy with something, we
then discuss putting it into the general front end for all users to see and
use.
We are maintaing a replica set in Access 2000 and one of
the replica users would like to create her own reports.
Does anyone know of a way to permit this -- I know report
creation is not enabled in replicas, but I'm hoping
someone is aware of a work-around. Thanks much.