Hiding a Table in Microsoft Access
This tip Hiding a table in Microsoft Access will explain just that, how to hid a table. Why you may ask?
You may wish to make some data not easily accessible to users,this is where hiding a table in Microsoft Access may come in handy.
Mind you this is not the be all and end all, other users can unhide a table if they no where to look, but for the majority of your users, hiding a table may just be enough.
To hide a table.
Right-click on the table and select 'Properties' from the drop-down list.
- Next to attributes, click on Hidden then, click on Apply. This will hide your table.
- Close the window. Your table will be gone.
To view your table:
- On the menu bar, click on Tools > Options.
- On the general tab, check 'Hidden objects' > Apply,
Close the window, your table will now be visible but paler than the other tables. Just uncheck 'Hidden Objects' to re-hide the table.
What you may like to hide:
- Personal information on staff
- Students results
- Health information
- anything you do not want general users to see (easily)
I realize this is not foolproof, but unless the users of your Microsoft Access database are proficient in Microsoft Access, they most likely will not know about this.
If you would like your data more secure than just hiding a table, then there are plenty of other things you can do, depending on how secure you wish your database to be, these could include:
- Open Access Options > Current database, and untick or tick the variety of options that are avaiable that limits what the user can do with the current database.
- Setting up a password for your database
- Saving your database as an MDE (or ACCDE Microsoft Access 2007 or later)
- Using user group security and more
My recommendation would be to read/refer to Garry Robinson's book as per below. It has helped me out on many occassions. Real World Microsoft Access Database Protection and Security