Wrox Programmer Forums
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old April 12th, 2011, 10:01 AM
Authorized User
Join Date: Dec 2003
Posts: 63
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to hide one table

i have many table but i want hide one particular table like password table from my mdb file it is passable
Mohamed Mohiddin
Old April 12th, 2011, 11:07 AM
Friend of Wrox
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts

See: How to Hide a table
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Old April 12th, 2011, 04:42 PM
gjgriffith's Avatar
Wrox Author
Join Date: Jul 2009
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default Hidden is not truly Hidden in Access

Hello mohiddin52,

I saw your question here and Boyd's answer is good for hiding your tables. However, this should not be confused with a form of database security, because any user of the database will still have the ability to get to the table if they know how to use Access (to hide and unhide the tables themselves).

For a more robust solution, you might want to implement User Level Security for the database application. However, ULS is only supported in the MDB file format and has been deprecated in the ACCDB file format sadly.

Anyway, I just wanted to mention that...so that you are also aware of the repercussions of using the Hidden property for a table. I hope that helps and good luck!
Geoffrey L. Griffith

Wrox Author of:
Microsoft Access 2010 24-Hour Trainer
Access 2010 Programmer's Reference
Access 2007 VBA Programmer's Reference

*** Please click the THANKS button (to the right) if this post helped you! *** ---------------------------------------------------------------------------------------------------------->
Old April 12th, 2011, 06:37 PM
Friend of Wrox
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts

I totally agree with Geoffrey. Jet and ACE are not very secure. If security is important then I would switch to an SQL server back end with Access as the front end.

It is very difficult to keep people out of viewing your tables directly. That is why I stated this at the bottom of the article in the link above:
If you need to hide a table like user names and password you should also consider encrypting the data.
Since you said "... one particular table like password table ..." then I would encrypt the data in the password field.

Also be sure to set the input mask to Password in the filed properties in the tale for the password field. This will make it display as *'s
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Similar Threads
Thread Thread Starter Forum Replies Last Post
hide certain column in a table lscjtw XSLT 2 August 2nd, 2007 01:26 PM
Hide/show rows in a table smi13y XSLT 6 December 28th, 2006 08:48 PM
Hide or Disable Table To Open vivek_inos Access VBA 2 December 8th, 2005 09:03 AM
Hide table with VBA mmcdonal Access VBA 5 June 24th, 2005 10:13 AM
How to hide a table TR oranginalab Javascript How-To 9 January 24th, 2005 04:35 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.