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

    disable tables ? (Access 2000)

    Is there any code to make the tables in a database somehow disabled or allowing no edits
    as it is in the forms?

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: disable tables ? (Access 2000)

    Not in Access.

    You can hide the tables, and disable ways of showing them again using the various options in Tools...Startup (including the Advanced options) .

    If you institute Access security you can also remove therights of certain users from making desing changes. If you also remove their right to add data to the table, they won't be able to do it via a form either so that is probably not what you want.
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: disable tables ? (Access 2000)

    If you implement User Level Security, you can deny users the right to view or modify the tables directly, but instead work through queries by using Read With Owners Permission queries (RWOP).
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

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