Hiding and showing Tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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..
 
Marco said:
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?
Click to expand...

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.
 
Back
Top