Lock down access to parts of DB

[TheStig]

Hi All

Running access 2000

What I want to do is lock down access to parts of the DB to user groups.

I know how to setup the groups.

But what I want to do is give

1, Telesales access only to the data entry form and not any other part of the switchboard.

2, Admin staff only access to admin & manager forms & switchboard

3, Managers access only to managers / telesales forms & switchboard

4, Directors i.e. the gaffer access to all the DB but lock them out from making design changes.

The Stig

 

[ecniv]

Do you have a login screen? user preferences/groups? or do you use an mdw workgroup file?


Vince

 

[TheStig]

Workgroup file

It asks for a UN & PW but I can't find out how to lock down

 

[ecniv]

I hope you have a developer/god log in on the mdw.
Log in as that.

BEFORE doing/experimenting with the below make sure you have backed up the mdw file and your mdb(s) that you will be changing. Nothing worse than losing everything.

Tools>security>permissions screen (I think from memory)
Select the user as say inputter.
Select the form and check the rights. For inputter you'll probably need run edit, new, update everything except design.
For any other forms they are allowed in, set each form for each user.
Note: You may (possibly) be able to set the group instead, but I have a feeling user preferences may override it.

If they are not allowed to view stuff, set it in the permissions.
Same for reports, queries, code etc.


Personnally I use the following:
Mdw with two extra logins:
Groups: Devs -- User: dev
Set devs to god mode and the user dev to god mode
** revoke Admin and user rights (the default logins) - once saved and logged in as developer.

In the mdb, you have a log in that the user must sign in their own login (or read it from environs) plus password. Internally the mdb then allows the users to view certain forms from your own menu or from a 'switchboard'.
I went as far as coding the menu creation from a table, so it locked it down more, plus the 'shift lock' trick stops most users from gaining access to your db and your dbs tables.


Vince

 

[TheStig]

Thanks

I See said the blind man

I never looked at that bit what a plonker i am