Hide tables in database window

  • Thread starter Thread starter TNL
  • Start date Start date
T

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
 
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 ... "
 
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
 
Hi,

Yes it can access tables that are invisible.

Here's the Access command:
Application.SetHiddenAttribute acTable,"Customers", True

Using DAO see the following warning:
http://www.mvps.org/access/bugs/bugs0036.htm

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."



--------------------
| From: "TNL" <[email protected]>
| Subject: Hide tables in database window
| Date: Sat, 6 Mar 2004 10:08:21 +0100
| Lines: 13
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <#[email protected]>
| Newsgroups: microsoft.public.access.modulesdaovba
| NNTP-Posting-Host: ge85f.g.pppool.de 80.185.232.95
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.modulesdaovba:126071
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| 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
|
|
|
 
Back
Top