Restricted access to DB

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

Hi All,
I have created a DB which is on a network shared by the entire company. I
would like to know how I can prevent the staff of one branch from accessing
the data of another branch. I would like each branch to only see their own
data.

How do I do this.

Thanks in advance for any assistance anyone can give me.

JT
 
You have a couple options

1. Split the database to give you a front-end and a back-end.
2. Make a copy of the front-end for each department and then restrict the
departments to their own menus
3. Install a relevant copy on each user's terminal, this will reduce the
amount of network traffic.

or

1. Assign an user id, password and access level for each user
2. Create a login screen with an user id and password, from the user id
determine the access level
3. Using the access level display the relevant menu


For security "Lock" the database so that user can not "bypass" the startup
by holding the shift key down.

Allan Murphy
Email: (e-mail address removed)
 
Back
Top