Hiding and showing Tables

[Guest]

Env Microsoft Access 2003 part of MS Office Professional, Italian version
Hi all,
in an application I'm developing I need to hide and show Tables
programmatically. I'm using the following statement to hide the Tables:
Application.CurrentDb.TableDefs("tableName").Properties("Attributes").Value
= dbHiddenObject.
This statemente hides my database Table and even if I close the application
and later I open it again the Table remain Hidden. This is what I want.
Anyway, how can I reverse this? Is there any dbXXXXObject value that can me
let to show the Tables back?
TIA
Marco Paci

 

[Guest]

Hi Marco,

From what I've read elsewhere previously, I seem to remember that
dbHiddenObject marks a table for deletion next time you perform a compact and
repair on the database, and the setHiddenAttribute actually hides the object,
can't lay my hands on where I read about it before, so don't take my word for
it, maybe a google search on both will help.

TonyT..

 

[Tim Ferguson]

I'm using the following statement to hide the Tables:
Application.CurrentDb.TableDefs("tableName").Properties("Attributes").V
alue = dbHiddenObject.

http://www.ureader.com/message/856366.aspx


Note the warning at the end!

Hope it helps


Tim F

 

[Granny Spitz via AccessMonster.com]

This statemente hides my database Table and even if I close the application
and later I open it again the Table remain Hidden. This is what I want.
Anyway, how can I reverse this?

Application.CurrentDb.TableDefs("tableName").Properties("Attributes").Value =
0

Even if you compact the database while it's hidden in Access 2003 it won't
permanently delete the table. Hiding tables in Access 97 and 2000 with the
dbHiddenObject attribute will delete them on compaction IIRC.