Re: Securing Tables From Data Changes

Sorry, 'RWOP'??. I don't know much about user-level security. We've never had
anyone who either knew how, or was inclined to by-pass, the start-up option
of hiding the database window. Could you please be a little more specific?
I'm willing to read knowledge base articles but can't seem to find the
appropriate one(s). Thanks for the help.

"Joan Wild" wrote:

> "Rick B" <Anonymous> wrote in message
> news:uqhYAq9VFHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
> > One way is to implement user-level security and take away the user's
> > access
> > to the tables. This will mean they can't open or modify the tables in any
> > way. Also, take away all access to the queries. Then, give them the
> > needed
> > access to the various forms they should be using.
> >
> > Since the forms are based on queries that they don't have access to, you
> > would get an error UNLESS, you set the queries to "run with owner
> > permission". Then, when they open the form, they will be able to use the
> > queries and perform the needed tasks.
>
> Not quite. They'll still need at least read data permission on the RWOP
> query in order to be able to read data. And it they need to
> add/modify/delete records in the form, then they'll need the appropriate
> permission(s) on the query.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>
.

Relevant Pages

  • Re: Securing Tables From Data Changes
    ... take away all access to the queries. ... > queries and perform the needed tasks. ... They'll still need at least read data permission on the RWOP ... query in order to be able to read data. ...
    (microsoft.public.access.security)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: "Query Too Complex" Errors
    ... few dozens of queries, in the middle of which there's a long chain of ... we've been having a lot of those "Query Too ... some of the complexity in the SQL ... SQL statement you are working on. ...
    (microsoft.public.access.forms)