Re: Securing Tables From Data Changes

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.

The Microsoft Security white pages has more details on this, if I remember
correctly.

--
Rick B



"jkmccnh" <jkmccnh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3843FC8A-56E4-4A11-9B73-F33A7CB9B599@xxxxxxxxxxxxxxxx
> I have an app that must log all changes to data (who, when, what). The
> problem is securing the tables so someone with Access know-how can't use
the
> shift key (bypass start-up options) to get to the tables and change data
> without a log entry being created. Access 2000 front end linked to SQL 7
back
> end. MDE will only secure the forms and reports. Thought of making the
tables
> hidden but again, someone with access knowledge will know how to turn them
> back on. Is there a way to generate a log entry when the table is directly
> accessed? Any other suggestions??


.

Relevant Pages

  • More index questions
    ... comparing them with the Index Tuning Wizard (ITW) to figure things out. ... is there a way to use the Profiler to "get the distinct queries [on ... fkey (security), two floats, a type, a date and a varchar notes ... Data is unique on fkey, ...
    (microsoft.public.sqlserver.server)
  • Re: User queries and security
    ... I make queries read only to a chosen user group (as defined by access ... I have most of my forms based on SQL statements in the record source ... everything under the bonnet from them and apply your security by ...
    (comp.databases.ms-access)
  • RE: Best way to share
    ... > I used this article to setup the security: ... > tables in the backend, the queries, forms, reports, etc. ... > the same security file but have permissions set differently. ...
    (microsoft.public.access.security)
  • Re: Restricting to view the design
    ... forms and reports but i'm not able to. ... To protect the design of tables and queries your best bet ... appropriate permissions to various database objects would also be needed. ... Access User-Level Security: ...
    (microsoft.public.access.security)
  • Re: Queries being modified
    ... Susan, ... The Security FAQ has instructions for creating a "remote site ... You would create RWOP queries using the development workgroup ... You could give the Admin user permission to open ...
    (microsoft.public.access.security)
Loading