Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a simple way of preventing any users bar myself from accessing
design views of a database without having to add users to certain groups and
using permissions because the users and access is changing frequently. I know
there is something i can do in VB but am not certain of the code required.
Would appreciate help
Thanks John
 
You can give your users an MDE which will prevent them from making changes
to the structure of your database.
 
Khartoum said:
Is there a simple way of preventing any users bar myself from
accessing design views of a database without having to add users to
certain groups and using permissions because the users and access is
changing frequently. I know there is something i can do in VB but am
not certain of the code required. Would appreciate help
Thanks John
Click to expand...

It is possible to set up security so that there are only two levels. You give
the default group "Users" the permissions required to basically "run" the app
with no permissions to design view of anything. Then you have another account
set up with full administrator privilages.

The nice thing about this setup is that "users" don't even need a particular
workgroup file. They open your app just as if it were unsecured with no login,
and no need for a special shortcut, BUT...they are still limited to the
permissions that you have given the "Users" group.

The administrator account will still need to use the secured workgroup file and
login to do admin stuff, but regular users require no maintenance at all.
 
Back
Top