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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't create a report from my query in Access 1
How to Convert EML to PST files? 0
Cross Tab Report Vs Dynamic coulmns 0
Having user define a report criteria 1
Prevent users from accessing report design mode 1
Change table associated with report 1
Calculating Percent of a Group in Report Footer 2
How do I modify the query on which my report is based 1

Back
Top