Hiding tables

[Lilian]

Hi!
Is it possible to hide tables? I want that not all the users can see all db
tables when they make the queries. The db is splitted and placed on server.
In db is made authorization and there are different kind of users.
Best regards,
Lilian

 

[Jack Leach]

I believe if you prefix the table name "USys" it will be hidden, unless the
database property show hidden tables is true. The same behavior will go for
Access system tables, which are prefixed "MSys" - they are hidden as well.

Or, without having to prefix the table name USys you can right click on the
table, select Properties, and click the Hidden checkbox

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Douglas J. Steele]

Right-click on the table and look at the Properties. You can set them as
hidden there.

Of course, any one who wants to can see hidden objects by going into Tools |
Options and check "Show hidden objects"

 

[Lilian]

Hi,

When I tryied to hide the desired tables the diasppear from navigation pane
but not from the quiredesign there all db tables are visible. Everyone can
make queires based on these tables that is not good at all.

Best regards,
Lilian



"Jack Leach" skrev:

 

[Lilian]

Sorry, now they disappear.
Thanks you very much

"Jack Leach" skrev: