Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tables inaccessible to users (Access 2000)

    Sometimes my users neglect the forms i have provided for editing the tables, and make some changes in the tables themselves.Is there any way to prevent the users to have any access to the tables? I use Front En d with linked tables and i am curious to know is there any way to prevent users from liikong up the tables themselves ?

  2. #2
    Star Lounger
    Join Date
    Dec 2001
    Location
    Birmingham, Alabama USA
    Posts
    95
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tables inaccessible to users (Access 2000)

    The only sure way to do this is to set up User Level Security. You can then set the "permissions" for the Groups to not allow access to the specific obects you do not want to to have access to.

    HTH
    RDH
    Ricky Hicks
    Microsoft MVP
    Birmingham, Alabama USA

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tables inaccessible to users (Access 2000)

    You can also set the tables property (and your other objects too) Attributes to Hidden.

    Right click on the table, select

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Tables inaccessible to users (Access 2000)

    There are two ways to set a table to hidden. The way you suggested works properly in all the versions and won't cause tables to be deleted.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •