Hide Table

G

Greg

I have never done it but an obvious way would be:
1) You check in which Groups the User belongs by checking
the Groups Collection of that User Object.
2) If it comes out the Table should be hidden, You go to
the TableDef Object of that Table and set the
dbHiddenObject Attribute in the Attributes Property of
that TableDef
(TableDefs("ItsName").Properties("Attributes"))
3)Then you refresh the Database Window and the Table is
hidden.
If the Table should not be hidden you unset the Attribute,
refresh the Database Window and it is there again.
Of course the User could select to "View hidden Objects"
and all that was for nothing.
Why do you want to hide the Table and don't you just
restrict its Permissions?
Merry Christmas
 
T

TC

NO. dbHiddenObject is an internal system constant. It will often cause the
table to be >deleted< on the next compact.

TC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top