How allow users to modify and create reports?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to allow users to modify and create reports without
compromising the integrity of the database. I guess I need a way of making
all existing reports, forms, queries and modules read-only. Or can I make
them invisible like the 'Sys' prefixed tables. Is there any way to disallow
UPDATE or DELETE in queries? I'd prefer to not use user-level security.
 
If you make your application into an MDE then users will not be able to
modify forms and reports. Tables and queries are always modifiable unless
you implement user-level security. You can name your objects "usysWhatever"
and they will become hidden.

If you want a solution that allows users to create custom query/reports,
consider the query by form applet available at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane
 
Back
Top