Database table hidden

[data808]

How do you keep the database table hidden from the employees who are entering data into the forms. When I open the access file, on the left side of the screen I could just go into tables and check out the database and edit records.



This is what I want to prevent. Is there a way to just have the form open up and have the database hidden somewhere that the data entry clerk will not be able to see?

Sorry I'm new to Access. Still trying to figure out if I'm using the program correctly.

[Evilferret]

(1) Right click on the table (Or form, query, report, etc) and select "Hide In This Group" to hide the object

(2) To see the object again, right-click on the top of the object browser and select "Navigation Options..." then check off "Show Hidden Objects"

You might want to consider splitting your database. This will allow you to have one potion of the database that is only data (Tables) commonly called the BackEnd. You end up with a separate portion of the database that contains all your forms, queries, etc called the FrontEnd. This is better for security, makes it easier to run your database across a shared network and various other benefits.

For more information on splitting databases, read here:
http://www.access-experts.com/defaul...lSplitDB&sm=18

[June7]

Yes, can set database properties. http://office.microsoft.com/en-us/ac...41609.aspx#BM1

Be aware that holding down the shift key while opening db will override most of these option settings.