Set linked tables Hidden property

  • Thread starter Thread starter Dale Fye
  • Start date Start date
D

Dale Fye

I want to hide a bunch of linked tables in my database
window. I have some users that use my application to link
to tables in an oracle database. I would like to hide
some of the system tables I use so that the users only see
the tables they have linked using the application.

I know how to hide these at design time, but my
application provides a mechanism for them to link to a new
database. When that happens, I have to relink these
system tables using TransferDatabase, and they come in
with the hidden property set to false.

I've tried:

currentdb.tabledefs("tableName").properties("hidden") =
false

but that does not work. All suggestions would be
appreciated.

Thanks!
 
According to http://www.mvps.org/access/bugs/bugs0036.htm
you don't want to do that.

I'm not sure if that has been fixed or not. The best
alternative is to name all your tables/queries starting
with "USYS" ("USYSLookupFields"). This way the only way
they will show up is if the user selects to see system
tables.



Chris
 
Chris said:
According to http://www.mvps.org/access/bugs/bugs0036.htm
you don't want to do that.

I'm not sure if that has been fixed or not. The best
alternative is to name all your tables/queries starting
with "USYS" ("USYSLookupFields"). This way the only way
they will show up is if the user selects to see system
tables.
Click to expand...

I like Chris's suggestion, and his warning is well taken. However, if
you don't want to change your object names, you can set the hidden
attribute safely like this (from the help file):

Application.SetHiddenAttribute acTable,"Customers", True
 
It's all about knowing the object model, isn't it.

Thanks, Dirk. That is exactly what I was looking for.
 
Back
Top