Programatically hide a table?

[Guest]

Is it possible to programatically hide a table like the tables prefixed with
Usys.
If you click View--Properties on a table there is an attributes 'Hidden'
checkbox, indicating this may be possible.
I looked in the object browser at the DAO classes and found
tabledef.attributes and a value of dbHiddenObject but I dont know the syntax
to set this value. There is also a class in ADOX called Properties which I
think may also be usable. Does anyone have knowledge of this?

 

[Guest]

I figured this one out myself, if anyone is interested its:
Application.SetHiddenAttribute acTable, tblName, True

-Dorian

 

[John Mishefske]

I figured this one out myself, if anyone is interested its:
Application.SetHiddenAttribute acTable, tblName, True

I'd make sure you have a backup before you do that. Here's a post from Google (it may wrap):

http://groups.google.com/group/comp.databases.ms-access/msg/fed133b8eb6e3098?dmode=source