set permissions on shared database

  • Thread starter Thread starter Susan VanAllen [MVP]
  • Start date Start date
S

Susan VanAllen [MVP]

Good morning all and thanks in advance. I'm probably missing something
simple, but can't seem to find an answer in either the help files or the
online KB, so if someone can point me in the right direction I'll be
extremely grateful.

I have an Access 2000 database on a server share (Win NT server, users
either 98 or XP if it matters). There are only 5 or 6 users, but I have a
couple who like to create queries and alter existing queries, which breaks a
lot of the reporting. I hate to make them log in, but that's acceptable if
need be. The problem I'm running into is that if I set permissions, it only
applies to the workstation I set them on, and not on the others. Even
setting perms then creating an mde file rather than having them access the
actual database doesn't help. (Also, an mde file is impractical as this is a
fairly new project, with constant design changes required)

So... how do I set permissions globally rather than on each workstation? Or
do I need to go to SQL?

SusanV
 
You need to read and follow all steps in the Security FAQ and articles.
When you say you "set permissions" what you mean is that you set up
permissions and users on some workgroup file on your PC. You never took
away permissions for the "ADMIN" user. Anyone who opens your database with
their default SYSTEM.MDW fiel is signing in as ADMIN. Since you still have
full permissions for ADMIN, they are able to have full access.

You need to read all the steps involved in securing a database, make a
backup or two, and then dive in.

Security in Access is NOT easy or trivial. Make sure you understand all the
steps before you begin.

Rick B
 
Hmmm, no I think perhaps you misunderstood. I know how to create users and
groups and all on a local machine - for example Admin has a password, john
and Joe are read-only users, Kathy can design forms and reports but not
alter table structure. Works fine on a local machine - what i don't know how
to do it to distribute this to the various users.

Maybe I haven't read far enough, I'll give it another look.

Thanks!
 
Ah.

You created your users, groups, and permissions in your "workgroup" file on
your PC. The other users will need to use that workgroup. It will need to
be placed in a public location. You will want to create a shortcut that the
others use to open your database and include the workgroup path in your
shortcut.

You may want to verify though that they can't access your database with
their default workgroup. In other words, if they try to get to your
database from their PC they should get an error and not be allowed to access
the fiel.

Rick B
 
Thanks yes, that's what I was after. I'll have to set up a test db and play
a bit, but I think this is do-able, especially since it's only about 8 PC's
to set up the shortcut on.


Thanks tons Rick!
 
SusanV said:
Thanks yes, that's what I was after. I'll have to set up a test db and
play a bit, but I think this is do-able, especially since it's only
about 8 PC's to set up the shortcut on.
Click to expand...

The example on my web site might be of assistance too ...

www.keithwilby.com
 
Back
Top