How to add an Attribute to a table?

  • Thread starter Thread starter Mota
  • Start date Start date
I don't have A2K loaded on this PC, so I can't look
at the moment, but there is an Application method
exposed which changes the Access hidden property.

Van: I never bothered to test it, but when A2K came
out the VB6 people were adamant that the Jet temporary
object flag was no longer in use by Jet. Again, I can't
test at present, are you sure?

(david)
 
David

I tested it in A2K2 and the code worked. I didn't test whether the Table
used is deleted on Compact as it was a working database I tested on.

Will test (in A2K2) and post back later.
 
Mota said:
How can i make a table hidden thru code?
Thank you for your help.
Click to expand...

application.SetHiddenAttribute objecttype, objectname, True/False

(david)
 
In Access 2000 I just ran this:
codedb.tabledefs("Table1").Attributes = _
codedb.tabledefs("Table1").Attributes or dbHiddenObject

which hid the table, then compact/repair from the menu, then
this:

codedb.tabledefs("Table1").Attributes = _
codedb.tabledefs("Table1").Attributes xor dbHiddenObject

which unhid the table.

I don't know what Jet is using now for tmp objects, but it seems that MS,
rather than just taking the obvious step of renaming the property to
correctly reflect it's function, changed the function to match the name.

(david)
 
It looks like Access 2000 / JET 4.0 no longer deletes Tables hidden by code
....

Thanks for posting back ...
 
Back
Top