hide a table

From: betty (betty75902@yahoo.com)
Date: 04/07/03

  • Next message: BP Margolin: "Re: hide a table" 
    From: "betty" <betty75902@yahoo.com>
Date: Mon, 7 Apr 2003 13:47:04 -0700

    I have a SQL database with an Access project back end.
    Users need to update a single field in one table. I built
    a form and restricted their view to only employees in
    their department;and update to the specific field. This
    works great. However, if the user selects tables, the
    table with the update field is visible. Even more
    critical, any user can modify any field. There are
    numerous jobs, stored procedures, and views that utilize
    this table. Any ideas on how to hide the table in Access,
    or restrict users from changes, except via the form?

  • Next message: BP Margolin: "Re: hide a table"

    Relevant Pages

    • restricting usage
      ... Does XP Prof have anything built in that could restrict the amount of time ... or the hour of the day that my kids spend on the computer? ...
      (microsoft.public.windowsxp.help_and_support)
    • Re: Can I protect columns Access 2002?
      ... If this is all you want to do, you may be better off using Excel. ... > I built a very simple table. ... > restrict the user from editing the 1st two columns. ... > the user fron deleting or appending any records. ...
      (microsoft.public.access.gettingstarted)
    • Unable to create MDE from secured database
      ... I have built an access project and have assigned a separate wrkgrp ... file to it also (i.e I have made it through Security wizard and have a ...
      (microsoft.public.access.formscoding)
    Loading