how to limt access to database.

[Guest]

i made an application for order/invoicing program. it is being used by 6
workstations on lan. How can I make it so that one work station (let say
shipping)
can only access the packing list and orders tables. One work station can
only access
(let say sales people) the inventory/open orders tables. Will appreciate
any input.
TIA
Alberto

 

[Guest]

I'm not saying what you are mentioning is not possible, but it would required
programming and there are variable factors that could make it rather
difficult.

Your better option is to simply implement Access' built in user level
security - create an account for your user which would control what they have
access to.

Tool*Security*User-Level Security Wizard...

 

[Guest]

Daniel's answer is correct; however, take some warning. Before you implement
Security, you should do as much reading on it as possilbe. It is not a
simple task. Be sure you have a backup copy of your database. It is
possible to lock it down so tightly, nobody, not even you, can get into it.

 

[Guest]

Would hiding your tables behind forms and then using a login function ( or
pulling their network ID ) to control access to those forms work?