giving users ability to produce queries and reports

[stevekos07]

When distributing an Access database, is it possible to make a limited range of development options available to users. For example the ability to generate a query or report, but without access to all of the objects?

Obviously splitting the database is important to prevent tampering, but is it possible to scale up and down various degrees of access to certain features while preserving others? I am aware of user-level security but I have limited experience with this.

 

[stevekos07]

No worries. It's simple. I found another post on this. Set up a "sandbox" private version of the database for each user that needs one, with links to the tables and let them play!

 

[MarkK]

Steve, thanks for posting back with that solution!

 

[stevekos07]

One other thing I thought of. If you are nervous about users editing tables, make the database effectively "read only" by locking all records, so that queries and reports are only available for existing data. In my case that isn't much of an issue because the users I would give a sandbox version to are pretty responsible.