hi
i have many table but i want hide one particular table like password table from my mdb file it is passable

__________________
Mohamed Mohiddin
Officer

See: How to Hide a table

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

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
http://www.ImagineThought.com

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! *** ---------------------------------------------------------------------------------------------------------->

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:
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