Hide tables in database window

[TNL]

Hi,

Access had a feature: user can determine, if a table is visible or not in
database window. I have following questions:

- when a program uses DAO or ADO to access the database, can it access the
tables, which are set to "unvisible"?
- How can I set this property (to unvisible), with DAO (or with access
command)?

Thanks

 

[Scott McDaniel]

If you can open the database with DAO, you can access the tables. The only
way to completely disallow access to the tables is to CORRECTLY implement
User Level Security and then provide access through RWOP queries (after
which you can disallow ALL access to your tables). There is information in
the MS Security FAQ regarding this:

http://www.google.com/url?sa=U&star...aq.asp&e=1102&mr=D/1!6295_,4!a_D:nr1m_spb2_mo

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "

 

[TNL]

thanks,
can you tell me, how can I with VBA DAO hide tables in DB window? I think, I
need to create a property:
db.tabledefs("xxx").properties.add...; value = false
But I don't know the property name.

TNL