Re: Locking in Queries for Reports


"Donald Calloway" <drcalloway@xxxxxxxxxxx> schreef in bericht news:2dSxj.43311$R_5.28324@xxxxxxxxxxx
I have written an application which includes 13 reports based on 39
individual queries. If a superuser happens to open any of these queries
and performs filtering of a dataset to satisfy a particular demand for
information outside of a report then re-saves the altered query by
accident, whenever a report on which that query is based is run the
results will not be as expected. How can a query itself be set as
read-only so that it cannot be modified by accident so this doesn't happen?

Is your app secured ??
You can't make query's read-only when the app is not secured.
==>> Teach your superusers to make and use their own query's.

A few other idea's:

Give them a few 'own' query's to use.
You could make copies of the needed query's and give these query's names like
_QrySuperUser_FilterOnWhatever and such

Or give them another frontend for analysing purposes.

Arno R

.

Relevant Pages

  • Re: Im stuck can not get total sum correct
    ... It works, I went through my SQL and saw that Total Accident was still there, ... I remove it from the query and run my report, ... You have stated earlier that each employee belongs to a single department. ...
    (microsoft.public.access.reports)
  • Locking in Queries for Reports
    ... individual queries. ... whenever a report on which that query is based is run the ... read-only so that it cannot be modified by accident so this doesn't happen? ...
    (comp.databases.ms-access)
  • Re: Query Too Complex
    ... switch the first query to use ODBC tables I get query too complex. ... the individual queries they work all the way to the very last ...
    (microsoft.public.access.queries)
  • Re: Query miscalculations, why?
    ... I got rid of the totalling query, ... >subreports directly with the individual queries. ... >I now set my Detail section to be invisible, the data changes! ... since I have no idea how your report is structured ...
    (microsoft.public.access.queries)
  • Re: Union sort
    ... I have a specific sort order that I need to maintain - this sort order is ... built into the individual queries, but not the union query that joins them ...
    (microsoft.public.access.queries)