Results 1 to 13 of 13
  1. #1
    Star Lounger
    Join Date
    Mar 2004
    Location
    White Oak, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hiding Tables (2002 - SP3)

    Is there a way to hide a table in the Tables tab of the database window but still allow access to it programatically?

    We have some tables that only certain people should be able to see and query but we want those tables to be accessible through code (We hide the tabs that show the data on the forms that display the data by using code to determine which group the operator belongs to). Obviously, we want the data to be accessible on those certain tabs by those that are able to see the tabs.

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    John,
    You should be able to right click on it, go to properties, and choose 'Hidden'. If there are certain people you wish to keep from looking at your tables and you're using a front end/back end split design use the database security wizard, or at least go to Tools> Startup > and uncheck 'Show Database Window' in your "deployed" front end databases.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Tables (2002 - SP3)

    You can hide a table by right-clicking it in the database window, selecting Properties from the popup menu and ticking the check box labeled Hidden. It'll only work if the user has not set hidden objects to be displayed; this is a setting in the View tab of Tools | Options...

    Note: in my opinion, end users should never see the database window - I always clear the check box "Display Database Window" in Tools | Startup...

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    .... <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>

    <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Tables (2002 - SP3)

    Yup, I was still composing my reply while you posted yours. At least, we don't contradict each other. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  6. #6
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    >>At least, we don't contradict each other

    I was actually quite pleased with myself...for once a helpful post, not a question, and Hans agreed! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Hiding Tables (2002 - SP3)

    ....and in addition to Hans's and Jeremy's non-contradictory answers <img src=/S/grin.gif border=0 alt=grin width=15 height=15>, deselect the Allow Full menus option in the start up that would allow people to view this option.....that is unless they know the shift key whilst starting trick <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    Jerry

  8. #8
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    I suppose I'll take the bait, and give the link to <post:=278,139>post 278,139</post:>, where you can learn how to disable the shift bypass key.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  9. #9
    Star Lounger
    Join Date
    Mar 2004
    Location
    White Oak, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    Hans,
    Yes, that is a good idea but I'm trying to allow users to write queries on tables that it's "OK" for them to see but not to be able to see other tables.
    If I hide those tables that I don't want them to see, can I still address those tables through the DAO process in VB?

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Tables (2002 - SP3)

    Yes, hiding a table is only relevant in the Access interface. DAO "sees" all tables, whether they're hidden or not.

  11. #11
    Star Lounger
    Join Date
    Mar 2004
    Location
    White Oak, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    Hans,
    Thanks for the prompt reply.
    Is there a way to hide certain tables by addressing an attribute of the table? I have two groups here, one who should see all tables and one that should not have access to certain tables. I have an opening form by which I can hide certain toolbars based on their group membership in the workgroup, using the OnOpen Event. Is there a way to do that with tables?

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Hiding Tables (2002 - SP3)

    I would create different front ends for each group of users.

    Or, as I suggested earlier, don't give users access to the database window at all. You can determine what you show on a form depending on the user login.

  13. #13
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hiding Tables (2002 - SP3)

    I agree with Hans, although User groups assigned via the security wizard would create an ideal solution.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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