G
GPO
Hi,
I have an Access 2000 database that will mainly serve a reporting role. The
data in it should be largely static with periodic (weekly) refreshes. It
will probably consist of a back-end containing the data, with each user
having their own front end with links back to the backend. Wondering what
the best way would be to set the database up so that users had read-only
access to the data tables, but still had the flexibility of configuring
their own queries if they want to (no action queries on the back-end tables,
mind you). The crucial thing is that they can link to the back-end but can't
change the data in it. Anything they do with the data (say a make table
query for example) should be done on their own front end.
I have an Access 2000 database that will mainly serve a reporting role. The
data in it should be largely static with periodic (weekly) refreshes. It
will probably consist of a back-end containing the data, with each user
having their own front end with links back to the backend. Wondering what
the best way would be to set the database up so that users had read-only
access to the data tables, but still had the flexibility of configuring
their own queries if they want to (no action queries on the back-end tables,
mind you). The crucial thing is that they can link to the back-end but can't
change the data in it. Anything they do with the data (say a make table
query for example) should be done on their own front end.