Table Security

[jiayue]

I am constructing a DB for my company who manufacture consumer toiletary products e.g shower gel, shower cream, shampoo ..etc. In the DB ,one of the table on the product formulation which build by the BOM (Bill of Material) & it must be kept highly confidential. This table, so called BOM contains all the necessary information e.g Product/Spec/Material/Dosages & is been used for many purposes in the query , form or report.

Also this file will be used /shared by many person & kept in a public directory in my company LAN system.

Question is, how can I keep this table not able to be seen by anyone else except with a password? or others ways...

On the others hand, if it can be "hide" by password or anyway, how can I get this table to be "edit" if I would like to change something /formulation in the BOM & not allow others person to see the other details. Please help to make a form /interface for changing /edit the details in the table.

Thanks

Jiayue

 

[willir]

Jiayue

You can impose security within Access. Create groups, and assign security according to the group.

Here is a trick...
For the extremely confidential information, you may consider creating a one-to-one relationship with the public and confidential data - one table with public info, the other with confidential info.

Then take advantage of the network security, and use multiple backends - one backend database is located in the "public" area, the other is located in a secure area where only authtorized groups, per network security, have access.

Then have the front end database distributed to the desktop. You may choose to have more than one front end.

Since you have a bill-of-materials database, you will have to either ensure that when the production sceduling is planned / implemented, that the process works with the limited security, or the person doing the scheduling for production (descrete or contineous) has access to all data.

Make sense, or is a further explanaiton requried?

Richard