Question Set password for tables and forms

[Mohamed Ali]

I have a receptionist which uses a database that contains everything in the company ..there is an employee table that contains their salaries and I want to set password for this table so that the admin is the only person who can view this table .......... is that possible??
and the same thing for a form that controls this table!
thanks in advance

 

[Pat Hartman]

If you are using A2007 or newer, there is no way to secure individual objects. You will need to lock down the app as best you can by hiding the nave pane, converting to accde and making sure that users can only see forms. You will also need to add security so that you control who sees what forms.

 

[Joe8915]

Pat, what about using "Manage Users & Permissions" ?

 

[Pat Hartman]

ULS is only available for .mdb's. It is not available for .accdb's.

 

[Joe8915]

You are so ever correct