Hide a table via VBA ?

[mscertified]

'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 don't 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?

 

[mscertified]

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

-Dorian

 

[Jeff Boyce]

If your table is prefixed w/ USys, Access will treat it as a "system" table.

If your options are set to NOT display system tables, your USys... tables
won't show.

It isn't necessary (and is possible redundant and/or confusing in the
future) to also "hide" the table.

Regards

Jeff Boyce
<Office/Access MVP>

 

[mscertified]

my tables are not system tables.

If your table is prefixed w/ USys, Access will treat it as a "system" table.

If your options are set to NOT display system tables, your USys... tables
won't show.

It isn't necessary (and is possible redundant and/or confusing in the
future) to also "hide" the table.

Regards

Jeff Boyce
<Office/Access MVP>

 

[Jeff Boyce]

Access treats a table whose name is prefixed with USys as a system table.
Sorry if I wasn't clear before...

Jeff Boyce
<Office/Access MVP>