Hiding Tables (2002 - SP3)

**jstegman** · 2005-12-17 22:55

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.

**NYIntensity** · 2005-12-17 23:01

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.

**HansV** · 2005-12-17 23:05

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...

**NYIntensity** · 2005-12-17 23:06

.... <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>

**HansV** · 2005-12-17 23:09

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>

**NYIntensity** · 2005-12-17 23:13

>>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>

**Jezza** · 2005-12-17 23:28

....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>

**NYIntensity** · 2005-12-17 23:34

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.

**jstegman** · 2005-12-19 18:05

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?

**HansV** · 2005-12-19 18:10

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

**jstegman** · 2005-12-19 18:37

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?

**HansV** · 2005-12-19 18:55

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.

**NYIntensity** · 2005-12-19 19:07

I agree with Hans, although User groups assigned via the security wizard would create an ideal solution.

Thread: Hiding Tables (2002 - SP3)

Thread Tools